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