Using Custom Views with Protected Worksheets

B

Beverly

I'm using custom views and I have 19 tabs that reference each other - one tab
has a graph and a pie chart. As soon as I try to protect any of the
worksheets I cannot use custom views - a dialog box comes up "Some view
settings could not be applied". Is there a way around this? I'm using Excel
2003.
 
B

Beverly

That's all I get is the dialog box that states "some settings could not be
applied". After a lot of trial and error I figured out it was when 3 other
sheets were protected that I couldn't apply the custom view to the other
sheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom views in protected worksheets 1
Bizarre Custom Views behavior 2
Custom views return error 1
Custom Views 2
Help with Custom View 2
Custom Views and Protected Sheets - 2003 2
custom views dialog box 2
Custom View: Keeping worksheet hidden? 1

Top