setting ScrollArea problem

[jjk]

Hi,

I have a worksheet with a lot of data. A number of rows are hidden and
all of them have merged colums.
The worksheet is protected as well.

I am trying to set the ScrollArea property of the worksheet for the
enitre UsedRange. However I am not able to view the last few rows of
the sheet. I cannot view it even if I increase the row upperlimit of
the scroll area.
Is there a fix for this?
Is there any another approach to limit the user scrolling?

Thanks,
Jayant

 

[Rob Bovey]

Hi Jayant,

I've run into this problem quite a few times, and the only solution I've
found is to set the scroll area to a range many rows taller than the actual
scroll area. Depending on the size of the actual scroll area I've had to add
as many as 200 to 300 additional rows to be certain the user could always
scroll to the bottom.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

 

[jjk]

Thanks Rob.

I was hoping there was a clean solution to this.
I guess I will set the property as you have suggested.

Regards,
Jayant