Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's in a (macro) NAME?
Chuck,
You are seeing some macros that are in the activeworkbook (those without a prefix), and some in other workbooks (with a prefix). It cannot be avoided. You need to specify the prefix with Application.Run if the macro is in another workbook, can't be avoided. -- HTH RP (remove nothere from the email address if mailing direct) "CLR" wrote in message ... Hi All...... When I do Tools Macro Macros, I get a nice list of all my macros. Only thing is, some of them are named just the name I gave them, and some include the FileName and/or ModuleName as a prefix. I don't like this, and "Application.Run ("MacroName") will not find the macro unless I include that prefix, which of course I do not want to do..........any way I can keep the Editor from assigning these prefix's, or deleting them and/or renaming the macros so the new names will stick? TIA Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |