Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Viewing Custom Views in a protected worksheet
Is it possible to lock a spreadsheet and let others users see custom views
with the worksheet still being password protected? |
#2
|
|||
|
|||
Not that I know about--but I don't use customviews very often (never).
A possible workaround... Create a macro that is equivalent to each custom view. Add a few buttons from the forms toolbar and assign a macro to each button. Your macro could unprotect the worksheet show/hide columns/rows reprotect the workbook Arkitech wrote: Is it possible to lock a spreadsheet and let others users see custom views with the worksheet still being password protected? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Views Greyed Out | Excel Discussion (Misc queries) | |||
Custom Views Not Accessible | Excel Discussion (Misc queries) | |||
Custom Views in Pivot Table | Excel Discussion (Misc queries) | |||
Can I set my custom views on Pivot table | Excel Discussion (Misc queries) | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |