Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Macros disappear after a file is imported | Excel Discussion (Misc queries) | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |