Macro to only run on sheet1 IF the active sheet, what code?

[thecdnmole]

Hi, I am having a brain fart here. I have code that I only want to run when sheet1 is the active sheet. It can be called with keyboard shortcut keys from any sheet which is why I only want it to run when sheet1 is the activesheet. Probably simple, but I just can't get anything to work. Thanks!

[mjr veverka]

Try
(assign a shortcut to a new macro: 'macro_1')

Sub macro_1()
    If ActiveSheet.Name = "Sheet1" Then Call my_macro 'here the name of your macro (i.e. instead of my_macro)
End Sub

[Fluff13]

Another option.
Simply add this to the start of you macro

If ActiveSheet.Name <> "Sheet1" Then Exit Sub

[thecdnmole]

Thanks PV! I have been searching all morning and a minute after I posted this, I searched again and found much the same as what you suggested. https://www.mrexcel.com/forum/excel-...sheet-vba.html . Thanks.

[thecdnmole]

Hmmm, want a code to run if either of two sheets are Active, but this does not work?

If ActiveSheet.CodeName <> "Sheet24" Or ActiveSheet.CodeName <> "Sheet26" Then Exit Sub

[Fluff13]

Try

If ActiveSheet.CodeName <> "Sheet17" And ActiveSheet.CodeName <> "Sheet8" Then Exit Sub

and thanks for the Rep

[thecdnmole]

Thanks Fluff13, that works!

[Fluff13]

You're welcome & thanks for the feedback