Scroll Area

[George]

Hi.
In Properties set limit Scroll area, Save, Reopen, Properties goes into
default.
Is there any code to set it, at open etc.
Thank you
George.

 

[NickHK]

George,
Yes, that property is not retained ; you have to set it each time, probaly
in the WorkSheet_Open event.
Worksheet(1).ScrollArea = "A14"

NickHK