Change Macro names
 

I've been searching for a while for a way to control how the macro name
appears in the macro selection window. I understand that it must show
the name of the workbook it is associated to when there are multiple
open, but when there is only one, what can I do to JUST get the names
of the Subs in the selection box? What controls whether or not the
name of the module appears as a prefix for the macro?

For example, instead of this:
-----------------------
Book1.xls!Module1.Macro1
Book1.xls!Macro2
Macro3


I want this:
-----------------------
Macro1
Macro2
Macro3

Change Macro names
 

Hi Robb,

The module prefix is shown if Excel needs to distinguish between identically
named macros in different modules.


---
Regards,
Norman



wrote in message
ups.com...
I've been searching for a while for a way to control how the macro name
appears in the macro selection window. I understand that it must show
the name of the workbook it is associated to when there are multiple
open, but when there is only one, what can I do to JUST get the names
of the Subs in the selection box? What controls whether or not the
name of the module appears as a prefix for the macro?

For example, instead of this:
-----------------------
Book1.xls!Module1.Macro1
Book1.xls!Macro2
Macro3


I want this:
-----------------------
Macro1
Macro2
Macro3