Scroll Area
 

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.

Scroll Area
 

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

NickHK

"George" tron.net...
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.