Hi Jim

Thanks for the heads up!
I had not seen either your, or Gordon's post on my system when I posted my
response. I equally was unaware that the setting didn't "stick" on saving.

In all cases where I use the technique to prevent users accessing parts of
the sheet, I set it via code in the workbook open event, but thought that a
manual setting would also work and be a simpler answer for the OP.

Thank goodness we never stop learning!!!

Regards

Roger Govier


Jim May wrote:
But even after saving the Workbook;
Your Scroll Area is Lost;
See Gord's reply to my suggestion above..
Jim

"Roger Govier" wrote in message
...

Hi Paul

Right click on the worksheet Tab and choose View Code.
If the Properties window is not visible, press F4.
In Scroll Area, set the range of the area you require.

Regards

Roger Govier


Paul Dusterhoft wrote:

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?