Thread: Limit Scrolling

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

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" <edwardpestian.2a0aqp_1151320208.2996@excelforum-nospam.com>
a écrit dans le message de news:
edwardpestian.2a0aqp_1151320208.2996...rum-nospam.com...
>
> 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
>