Setting Scroll Area

P

Premanand

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.
 
N

NickHK

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

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

scroll area 1
Hiding Row and Column Index in a Worksheet 2
Scroll Area Problem 8
Scrolling a Text in Worksheet 1
Scroll Area 1
Setting Scroll Area in Excel Worksheet 5
Scroll Area 3
Scroll Wheel, Excel and VBE Weirdness 6

Top