Thread: Scroll Area
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default 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.