Problem When Scrolling Area


Posted by oeloel on August 04, 2000 8:51 PM

The problem that arrives when we develop a code to prevent users from scrolling outside of a visible area on a particular sheet is that if you save the workbook while being in another sheet in the same workbook where you don't want that scrolling limitation, and then open the workbook later with an auto open event --say, Sub Workbook_open ( )--, the sheet where you were on when you performed the saving gets limited to the scroll area originally set up for another sheet. Does anyone know how to make this not to happen?



Posted by Ivan Moala on August 05, 0100 3:03 AM


I suspect you are setting the scrollarea as
Activesheet.Scrollarea =
You should explicitly set your scroll area
to the sheet you want set, eg
Sheets("sheetname").scrollarea =
or indexed
Sheets(x).scrollarea =

HTH

Ivan