G Guest Feb 7, 2005 #1 Is it possible to lock a spreadsheet and let others users see custom views with the worksheet still being password protected?
Is it possible to lock a spreadsheet and let others users see custom views with the worksheet still being password protected?
D Dave Peterson Feb 7, 2005 #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
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
