Tools / Macro / Macros - which ones are these?

[michaaal]

How can I get my newly created VB Sub to show up when I
click Tools / Macro / Macros?
(Outlook 2003)

 

[Sue Mosher [MVP-Outlook]]

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?

 

[michaaal]

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.

 

[Sue Mosher [MVP-Outlook]]

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

 

[michaaal]

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

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?

 

[Sue Mosher [MVP-Outlook]]

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

 

[michaaal]

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

The subroutine has no arguments.

 

[Sue Mosher [MVP-Outlook]]

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