View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Unger Dave Unger is offline
external usenet poster
 
Posts: 153
Default Macro to create a shortcut to make next Worksheet visible

nde,
try something like this

Sub SheetAct()
Dim x As Integer
x = ActiveSheet.Index
Do
If x < Worksheets.Count Then
x = x + 1
Else
x = 1
End If
Loop Until Worksheets(x).Visible = True
Worksheets(x).Activate
End Sub

regards,

DaveU