Max,

Thanks but it still doesn't seem to be working, the range I want to be
viewed is a1:g97 (however the end reference varies as I have different
worksheets to apply this to).

Am I missing something here?

Cheers

"Max" wrote:

"Doug" wrote:
I am trying to limit the area that users of my spreadsheet can view, I have
tried using the scrollarea function which works until the spreadhseet is
closed, when I open it again it resets to allow users to scroll through the
whole worksheet.

Yes, reading from past posts, the setting is transient (doesn't get saved) ..

Try the sub below, which is to be placed in the "ThisWorkbook" module

Right-click on the Excel icon at the top left corener (just to the left of
"File" on the menu Choose "View Code". This will bring you direct into the
"ThisWorkbook" module. Copy Paste the sub into the code window on the
right

'----
Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "A1:B100"
End Sub
'---

Adapt the range to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---