Macro Problem

  • Thread starter Thread starter Guy
  • Start date Start date
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?
 
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?
 
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?
 
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?
Click to expand...
 
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?
Click to expand...
 
Back
Top