custom view

[kevin carter]

Hi
We have a workbook thatr we want to create custom views in
when we create the custom view(turn column & rows,scroll barand sheet tabs
off)
when we run the custom view we get an message box popping up say "Some View
settings could not be applied"

Any ideas what we doing wrong?


thanks

kevin

 

[Max]

Just a thought ..

Is worksheet protection applied ?

Example: when you last edited the file...
did you protect sheet
after hiding some rows / columns, etc
which were previously visible in the custom views?

If you did, then you'll probably hit the error:
"Some view settings could not be applied"
when you activate the custom view
--
Rgds
Max
xl 97

 

[Max]

Just a thought ..

Is worksheet protection applied ?

Example: when you last edited the file...
did you protect sheet
after hiding some rows / columns, etc
which were previously visible in the custom views?

If you did, then you'll probably hit the error:
"Some view settings could not be applied"
when you activate the custom view
--
Rgds
Max
xl 97

 

[Dave Peterson]

You may want to consider a VBA approach.

Record a macro when you make it look nice. (hiding columns, etc).

Then when you want that "view", run that macro.

(Record a macro that shows the worksheet in its normal state, too. Then you can
use that macro to show everything.)