Refering To Sheet Hosting Macro

Is there a preferred way of referring to the Workbook or worksheet which is hosting the macro.

For example say I have the following Macro:


Sub test()

Dim MyHostMacroWorksheet As Workbook

'''''''''''''''''''''''''''''''''''''''''''''''''
Set MyHostMacroWorksheet = Workbooks(1)

MsgBox (MyHostMacroWorksheet.Name)
'Works only if macro was inside first workbook opened
'''''''''''''''''''''''''''''''''''''''''''''''''


'''''''''''''''''''''''''''''''''''''''''''''''''
Set MyHostMacroWorksheet = Workbooks("foobar.xls")

MsgBox (MyHostMacroWorksheet.Name)
'Works but have to modify every time I copy code from workbook to workbook
'''''''''''''''''''''''''''''''''''''''''''''''''

End Sub
I am looking for explicitly saying "The Workbook/Worksheet that is specified by VBAProject"