Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Custom View settings

    Excel 2007 Windows XP sp3
    Is it possible to view the settings for existing custom views in a workbook - and how?
    either from ribbon or vba.

    Thanks

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Depends what you mean by settings. If you mean which rows and columns are hidden and what the print settings are, then no, other than actually switching to the view.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks Rory, it was actually the definition of the custom view just as you say.
    Once custom view is selected the workbook goes into long drawn out process of switching sheets and calculations run over and over again.
    I was hoping that the settings as to which worksheet and which columns/rows/views would be set in order to try and check the steps one at a time.
    Thanks for reply.
    alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •