Sheet Name conditional

[SignGuy]

I use a number of different templates I open for various tasks... I want to run a macro that will exocute differently based on which template I am using at that time.

To simplify the question... I want a message box to pop up and say "Yea" if I am using a template named "Good Order1" and I want a message box to pop up and say "Boo" when I am using any other type of sheet.

I tried the following macro but still got "Boo" in my message box when I ran the macro:
If ActiveSheet.Name = "Good order1" Then MsgBox ("YEA") Else: MsgBox ("Boo")

Please advise!!
Thanks!

 

[parry]

Hi heres an example. Note if the workbook has been saved it will include the extension - Good Order1.xls

Sub SignGuy()
    If ActiveWorkbook.Name = "Good Order1.xls" Then
        MsgBox "Yea"
    Else
        MsgBox "Boo"
    End If
End Sub

 

[SignGuy]

Thank you for the help! I got it!