Wasn't aware of this feature (?). LOL
Thanks,
Jim

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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?