View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Setting Scroll Area

Premanand,
You need to set this property each time the WB is opened; the Workbook_Open
event being the obvious place.

NickHK

"Premanand" wrote in message
...
I've mentioned Scroll area of a particular limits in my Excel Program. But

it
is not working once if I close and open the program again.
At the same time I've not mentioned about Scroll area in VB Coding. Just I
mentioned the Scroll area by modifying the properties of the sheet in VB
Editor.
Please suggest me whehter there is ay need for writinfg coding for Scroll
area.
Regards,
Premanand Sethuraman.