Setting Scroll Area
 

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.

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.