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?