Scrolling

[Guest]

I have created a worksheet to be shared by 4 other people but I want to limit
these users to be able to scroll the worksheet not beyond cell M60. How can
I do that???an anybody help.
Thank you

 

[Guest]

I don't believe it is possible to limit scrolling in Excel. However, what if
you Hide all rows after 60, and all columns after M? Users would still be
able to scroll beyond these limits, however they would not be able to see the
contents of these hidden areas.

HTH,
Elkar

 

[Dave Peterson]

You can change the scrollarea in code:

If you want to try, ...

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.ScrollArea = .Range("a1:M60").Address
End With
End Sub

Excel won't remember these settings after you close it and reopen the workbook
(that's why it's in auto_open).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm