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? |
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 |
All times are GMT +1. The time now is 06:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com