I probably need a little basic education on macro names.
I have a ‘Macro Menu’ macro that I wrote to help my ‘macro challenged’ users. This allows me to keep only one macro in our workbooks. This program will go out to the network where the latest version of all our macros reside, and get the names of all the macros and populate a menu for them to choose from. They can then select the macro to run and it will import the latest version and start it for them.
Sounds easy right ?
Well, I don’t know what causes the macro name to change in the ‘Tools, Macro’ window. Sometimes it is just the name of the Public sub, and sometimes it is: MyWorkbook!MyModule!MyProcedure.
The selected macro will upload OK, but will not always run. The error I get is the macro can’t be found.