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

The scroll area setting does not save when the workbook is closed. You have
to set it manually with the workbook_open event.


--
JNW


"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

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

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

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

I always use the sheet name that appears in excel on the sheet tab. Doing
this you need to use the quotation marks. If you refer to the sheet number
as provided by VBA you do not need the quote marks.
--
JNW


"Tim Davies" wrote:

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

I have got this code in the branch "microsoft excel projects", then "Sheet2
(Room Sessions):
Private Sub Workbook_Open()
Sheets("Room Sessions").ScrollArea = A1: AA72
End Sub

Yet this still does not help.

"JNW" wrote:

I always use the sheet name that appears in excel on the sheet tab. Doing
this you need to use the quotation marks. If you refer to the sheet number
as provided by VBA you do not need the quote marks.
--
JNW


"Tim Davies" wrote:

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