Good tip Jim but this method is also lost when you close the workbook.
Has to be reset when re-opened, hence my Workbook_Open code.
Gord
On Tue, 20 Sep 2005 19:06:14 -0400, "Jim May" wrote:
You can also
Right-Click on your sheet-tab
Select View Code
If Properties Window is not shown press F4
In Properties Window, near bottom you'll see
Scroll Area - In blank box to right
enter desired Range, say B2:G20
Exit out of VBE
Done
"Paul Dusterhoft" wrote in message
...
How do you set the Scroll Area on a worksheet so that the ability to move
around the sheet is limited to the selected area?
|