Tools / Macro / Macros - which ones are these?

  • Thread starter Thread starter michaaal
  • Start date Start date
M

michaaal

How can I get my newly created VB Sub to show up when I
click Tools / Macro / Macros?
(Outlook 2003)
 
Why would you expect a VB sub to show up in your VBA project? Or did you
mean "VBA sub"? Did you declare it Public?
 
No I didn't declare it as Public. It sounds like that may be my solution.
How do I declare a sub as public? I tried just putting "Public" in front of
it, but this didn't seem to solve the problem.
 
I'm still wondering if you meant "VBA Sub" when you wrote "VB Sub"?

Yes, you declare a subroutine public by putting Public in front of Sub.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Sue Mosher said:
I'm still wondering if you meant "VBA Sub" when you wrote "VB Sub"?

Yes, you declare a subroutine public by putting Public in front of Sub.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...


I apologize for not clarifying the difference. Would you mind helping me
out with this? I can tell you exactly the steps I took to create the sub if
that helps?
 
So this is VBA? Does the code run OK if you run it from the VBA environment?
Does the subroutine have any arguments?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Sue Mosher said:
So this is VBA? Does the code run OK if you run it from the VBA environment?
Does the subroutine have any arguments?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...

The subroutine has no arguments.
 
So this is VBA? What module did you create the subroutine in? Does the code
run OK in the VBA environment? Do other subs appear in the Tools | Macro |
Macros list?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top