|
-
Sep 27th, 2005, 05:47 PM
#1
Thread Starter
New Member
[resolved] Macro name changes (adding file name...)
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
Last edited by GuyGadois; Sep 28th, 2005 at 10:58 PM.
-
Sep 27th, 2005, 11:09 PM
#2
Thread Starter
New Member
Re: Macro name changes (adding file name...)
-
Sep 28th, 2005, 06:32 AM
#3
Lively Member
Re: Macro name changes (adding file name...)
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.
-
Sep 28th, 2005, 10:58 PM
#4
Thread Starter
New Member
Re: Macro name changes (adding file name...)
great, that is what it was. My module was named the same as my macro --> idiot, your ruining my life! :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|