Excel: Check active sheet before running macro 1

[krets]

How would I create an If statement to check the name of the active sheet and only continue to run if a certain sheet or sheets are active?

In this case I only want a macro to run if the "Data Processing" sheet is currently active. Otherwise I'm going to pop up a message box.

Is there an "ActiveSheet" property like there is an "ActiveCell"?

 

[AnotherHiggins]

->Is there an "ActiveSheet" property like there is an "ActiveCell"?

There sure is!

if not activesheet.name = "Data Processing" then exit sub
...

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[krets]

Perfect.

Thanks.