Printable View
Why is it when I try to start a macro by clicking a button it can't find it. What happens is that it may be looking for 'Macro1' but the macro now has a name that is 'filename.xls! Macro1.Mcro1' ? This is begining to be a real pain. Only a couple of them are like this and I can't seem to make them just appear like 'Macro1'
Does this have to do with me working on the macros on two different computers? How can I fix this?
Guy
bumpy
If the macro name has the same name as another macro, or is the same as the file's name this condition can occur. Even having a module named the same as a macro or file name can cause this.
Or perhaps the macro is embedded in the button and the workbook has been copied out and the macros is looking for the old file name.
great, that is what it was. My module was named the same as my macro --> idiot, your ruining my life! :-)