Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Views (2003)

    I am attempting to create custom views which display or hide hidden columns and rows.

    When I attempt to use the views, I get the message

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Custom Views (2003)

    Custom views don't work correctly if there are protected sheets in the workbook, even if the custom views don't involve a protected sheet.

    You could create a macro to unprotect sheets, apply the custom view, then reprotect sheets. For example:

    Sub ApplyView()
    With ActiveWorkbook
    .Worksheets("Sheet1").Unprotect
    .CustomViews("MyView").Show
    .Worksheets("Sheet1").Protect
    End With
    End Sub

Posting Permissions

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