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