ScrollArea Won't Save

[Todd Bardoni]

When I go into sheet properties and set the scrollarea and then save, close and then open again, the scrollarea disappeers. Any ideas why it won't save scrollarea?

 

[Dragracer]

Sorry you can't save the Scroll Area settings. Best create a macro to set the scroll area when the file is opened.

Now watch someone prove me wrong because I said "can't"

 

[Todd Bardoni]

Why is that option in there then? That's strange to put an option in the properties but you can't save it. Very strange...

 

[Juan Pablo González]

You can use the Workbook_Open event to restore it everytime. It is kind of strange that its not saved, but, you have to work with what's give to you, right ?