View Single Post
  #1   Report Post  
KR
 
Posts: n/a
Default 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.