Macro Problem

G

Guy

I have developed a module by inserting it in to my project in the VBA editor. I can't open the Macro for editing from the Tools | Macro menu, nor can I successfully launch it from a button. I can run it successfully from within the VBA editor and it is set as a public sub. I have renamed the project, exported the module and imported it back in. I've deleted and recreated the module (pasting the code back in) and I still can't get it to work as a macro. Any ideas?
 
S

Sue Mosher [MVP-Outlook]

Do you see it in the TOols | Macro dialog?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


I have developed a module by inserting it in to my project in the VBA editor. I can't open the Macro for editing from the Tools | Macro menu, nor can I successfully launch it from a button. I can run it successfully from within the VBA editor and it is set as a public sub. I have renamed the project, exported the module and imported it back in. I've deleted and recreated the module (pasting the code back in) and I still can't get it to work as a macro. Any ideas?
 
G

Guy

Yes it does. I've since renamed the module and it began working. Does it
matter if the module and the sub have the same name?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com


Do you see it in the TOols | Macro dialog?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


I have developed a module by inserting it in to my project in the VBA
editor. I can't open the Macro for editing from the Tools | Macro menu, nor
can I successfully launch it from a button. I can run it successfully from
within the VBA editor and it is set as a public sub. I have renamed the
project, exported the module and imported it back in. I've deleted and
recreated the module (pasting the code back in) and I still can't get it to
work as a macro. Any ideas?
 
S

Sue Mosher [MVP-Outlook]

I don't know. What's your experience with that?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


Guy said:
Yes it does. I've since renamed the module and it began working. Does it
matter if the module and the sub have the same name?
 
G

Guy

Not much. I usually don't do it but this one did have them the same. I'm not
sure if it had anything to do with it or not. Anyway, it works now
so..........

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com


I don't know. What's your experience with that?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers


Guy said:
Yes it does. I've since renamed the module and it began working. Does it
matter if the module and the sub have the same name?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top