Restrict Scrolling? Possible?

[NickyT]

Hello,

Because my last question was successful, i'd thought i'd ask another.

Is it possible to stop a user scrolling beyond a specific row/column?

For example, my spreadsheet has all its information within the cell range A1:L16, so there is no need for any other cells to be scrollable.

Anyone know the code (if any) behind this? and instruction on where i place the code? in the VBA editor. ("ThisWorkbook"?)

Thank you,
Nicky.

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Activate()
Me.ScrollArea = "A1:L16"
End Sub

 

[Domski]

In the VBA Editor select the worksheet so as it's properties are displayed and there is a field where you can define the scroll area of the sheet.

Dom

 

[NickyT]

Thanks for all your reply's,

Working now.

Nicky.

 

[lenze]

Just a side note: If you use Domski's approach, you will need to reset it each time the workbook is opened. For some strange reason, this change is not permanet.

lenze

 

[Domski]

Just a side note: If you use Domski's approach, you will need to reset it each time the workbook is opened. For some strange reason, this change is not permanet.

lenze

What a pointless setting!!! Never used it myself so hadn't found that problem.