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?