worksheet?
 

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

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

worksheet?
 

Use the ActiveSheet object to refer to whatever sheet is active:

If ActiveSheet.Name = "Current Month" Then
'do something

Hope this helps,

Hutch

"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

worksheet?
 

hi
probably more than one way to do this but...
If ActiveSheet.Name < "CurrentMonth" Then
exit sub
Else
runmorecode
End If

regards
FSt1

"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

worksheet?
 

Try something like

If ActiveSheet.Name = "Current Month" Then
' Current Month is active
Else
' Current Month is not active
End If


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"Looping through" wrote in
message ...
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