The available macros list in XL; how to suppress filename from showing

K

KR

Ok, this may be the dumbest question I've ever asked here :-/

Using XL2003 on Win2000

Usually I run everything from code or from command buttons. For this
particular project, I'm just leaving the code accessable via the macro list,
only exposing the macros I select (the rest are tagged private).

The first two macros show up in the macro list [tools/macros/macros] with
just the macro name, e.g. <TransferData>.
But the most recent macro I made shows up with the entire filename, e.g.
<'My File Name.xls'!BackupData>.

When I compare the macros, I can't distinguish any critical difference- they
are all in modules, all just start with sub, etc.

What causes the filename to show (or not show)? I even saved and closed the
file, to see if re-opening it would reset it to only show the macro name,
but that didn't work either.

I did notice that from within the VBE if I do tools/macros, it shows all
three macros without the filename.

Thanks,
Keith
 
K

KR

For what it's worth, I finally figured out what was happening- apparently if
the module name and the sub name are the same, XL feels the need to include
the whole path. I modified the name of my module slightly, and now I just
have the macro name in all cases.
The first two macros show up in the macro list [tools/macros/macros] with
just the macro name, e.g. <TransferData>.
But the most recent macro I made shows up with the entire filename, e.g.
<'My File Name.xls'!BackupData>.
Click to expand...


Keith
 
Top