Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |