Change Macro names

  • Thread starter Thread starter robb.carlson
  • Start date Start date
R

robb.carlson

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:
 
Hi Robb,

The module prefix is shown if Excel needs to distinguish between identically
named macros in different modules.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling excel macro not located in that workbook. 2
Automatically Excuting a Macro in a different workbook ? 10
Macro creation via VBA 26
Subject out of range 3
Help with activating window from Application.GetOpenFilename 4
Macro conflict 4
Macro conflict 1
Buttons re-assigned themselves to the right macro name but in Book 1

Back
Top