Where do I need the "'s and, should I use the Name of the sheet or the (name)
of the sheet?

"JNW" wrote:

In ThisWorkbook paste the following:
Private Sub Workbook_Open()
Sheets("mysheet").ScrollArea = "A1:D10"
End Sub

Make sure to change the sheet name and range. You can repeat the line for
all the sheets you want to limit.
--
JNW


"Tim Davies" wrote:

Thanks, How would I go about doing that?

"Tim Davies" wrote:

I have a problem in that I set a scroll area on a sheet in VBA, press the
save button in VBA, and then return to my worksheet, test the scroll area,
and it works perfectly. I then save the workbook, and close it. When I open
it again, it asks me wether I want to enable macros, so I do enable them, but
find that the scrool limits have dissapeared in VBA, and do not work in the
sheet.
Can anyone help/explain what I'm doing wrong?

Tim