I would like to assign a macro (which is in my current workbook) to a menu
command, but I would like the reference name of the macro to NOT include the
actual name of the workbook. For example, if I assign "Macro1" (no quotes)
to a menu command, Excel automatically expands that to "Book1!Macro1". I do
not want "Book1" to be referenced, because I frequently copy this macro
around to other books not named "Book1". When I try to use the menu command
in another workbook not named Book1, it complains because it can't find
"Book1!Macro1" (even though Macro1 is in the current workbook).

Using Excel 2003. Thanks.