View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GaryDK[_2_] GaryDK[_2_] is offline
external usenet poster
 
Posts: 10
Default Scroll locked in multiple worksheets

Hi Mac,

Paste this into the ThisWorkbook module. It should do the trick.

Option Explicit

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)

Dim ws As Worksheet

Application.ScreenUpdating = False
Application.EnableEvents = False

For Each ws In Worksheets
ws.Activate
ws.Range(Target.Address).Activate
Next ws

Sh.Activate
Application.EnableEvents = True

End Sub
Regards,

Gary