Custom Views

[Julie Wickham]

I have a workbook with a worksheet for each day then
another worksheet that summarizes the info from each day.

I have also created custom views on the "summary"
worksheet which hide columns and has print settings

These custom view work fine if there is no protection set
on any of the worksheets but do not work if protection is
set on any or all of the worksheets

Any clues ?? Protection of cells is a priority

Thanks
Jules

 

[Harald Staff]

Hi Jules

The easy way around this is some small macros that unprotects, displays and protects.
Assign a drawing toolbar textbox or a forms toolbar button to each one. Code goes
something like this:

Sub Macro1()
Sheets(1).Unprotect ("PWD")
ActiveWorkbook.CustomViews("FullView").Show
Sheets(1).Protect ("PWD")
End Sub

Sub Macro2()
Sheets(1).Unprotect ("PWD")
ActiveWorkbook.CustomViews("FilteredView").Show
Sheets(1).Protect ("PWD")
End Sub