Thread: worksheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
reklamo reklamo is offline
external usenet poster
 
Posts: 41
Default worksheet?

If ActiveSheet.Name = "Current Month" Then

regards
reklamo


"Looping through" wrote:

Is there a way to see if a certain worksheet is active in a workbook?

If it is active continue with code. If it is not active end.

this is what I got but it allows the code to keep going without the "Current
Month" worksheet being active.

If Worksheets("Current Month").Visible = False Then
End
Else

TIA
Peter