If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
custom views in protected worksheets
I run Excel 2003 professional and have created a workbook to be used by a
number of users. It contains a password protected worksheet into which data is entered. Users can manipulate the sheet with the protection on e.g. using auto filter. The workbook also contains a number of sheets with pivot table reports. These sheets are not protected. Custom views are used to display the columns different users want in printed reports from the data sheet. However these return an error message "some views could not be applied" when selected after the sheet is protected. The custom views cannot be applied after the sheet is protected. Is there any way in which the sheet can be protected but allow the custom views to be applied, without resorting to the use of macros? |
#2
|
|||
|
|||
custom views in protected worksheets
Instead of Custom Views, you can allow users to format the columns when
you protect the sheet, then they can hide the columns manually. To use the Custom Views, you'd need a macro that unprotects the sheet, applies the custom view, then reprotects the sheet. Cestbon wrote: I run Excel 2003 professional and have created a workbook to be used by a number of users. It contains a password protected worksheet into which data is entered. Users can manipulate the sheet with the protection on e.g. using auto filter. The workbook also contains a number of sheets with pivot table reports. These sheets are not protected. Custom views are used to display the columns different users want in printed reports from the data sheet. However these return an error message "some views could not be applied" when selected after the sheet is protected. The custom views cannot be applied after the sheet is protected. Is there any way in which the sheet can be protected but allow the custom views to be applied, without resorting to the use of macros? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|