Hi Dave and Steve,

I recant and apologise!

Never having attempted a non-VBA approach, I failed to address the
persistance issue and goofed!


---
Regards,
Norman



"Dave Peterson" wrote in message
...
But I think that this setting is forgotten when the user closes and
reopens the
workbook.

So I think that the macro approach is the only way.

An alternative (maybe)...

Hide all those columns/rows that you don't want the user to see. With the
worksheet protected, it'll be a little more difficult to select those
areas.



Norman Jones wrote:

Hi Steve,

To set the scoll area from Excel, displaying the ControlToolbox toobar
and
selecting the properties icon (the second icon) will give you access to
the
editable scroll area property of the worksheet.

---
Regards,
Norman