The available macros list in XL; how to suppress filename from showing
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
--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.
|