Return Sheet# Sheet Name

[Guest]

I notice in the VBA editor in the VBA project window there is always a Sheet#
and then the Sheet Name. For example: I change the name on Sheet2 to
"Journal" then in the VBA Project it wil show Sheet2 (Journal).

If in a macro I write:
MsgBox ActiveSheet.Name

It will return 'Journal' if I am in that sheet.

Question: I do I return to a variable the original name of the sheet that
appears in the VBA project window?

Thank you,

Steven

 

[Die_Another_Day]

Var1 = Sheets("Journal").CodeName

HTH

Charles Chickering

 

[Guest]

If you haven't just added the sheet with code,

Activesheet.Codename