| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Custom Views with Protected Worksheets
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. -- Thank you Beverly |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Custom Views with Protected Worksheets
What "view setting" could not be applied?
-- Regards Dave Hawley www.ozgrid.com "Beverly" wrote in message ... 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. -- Thank you Beverly |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Custom Views with Protected Worksheets
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. -- Thank you Beverly "ozgrid.com" wrote: What "view setting" could not be applied? -- Regards Dave Hawley www.ozgrid.com "Beverly" wrote in message ... 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. -- Thank you Beverly . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Views - Multiple Worksheets | Excel Discussion (Misc queries) | |||
| Using Custom Views in a protected worksheet | Excel Discussion (Misc queries) | |||
| custom views in protected worksheets | Excel Worksheet Functions | |||
| Hiding columns, custom views, protected sheet | Excel Discussion (Misc queries) | |||
| Viewing Custom Views in a protected worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
