What's the best way to limit scrolling on a worksheet. I've several
differnt examples that just didn't seem to work properly.

Any ideas?

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555518

Hello
Place this into Thisworkbook and amend accordingly:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "Sheet1" Then
Worksheets(Sh.Name).ScrollArea = "A1:C10"
End If
End Sub

HTH
Cordially
Pascal

"edwardpestian"
a écrit dans le message de news:
...

What's the best way to limit scrolling on a worksheet. I've several
differnt examples that just didn't seem to work properly.

Any ideas?

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555518