VBA Macros not showing up in the run macro menu

d.lee84 · August 20th, 2007, 10:10 AM

Hi all.
Sorry, this is actually in Outlook (2003), but I couldn't find a separate forum for Outlook VBA. The problem I'm having is that I've written some VBA code that I would like to be triggered by the click of a button available on the Outlook menu. I go to the customize menu, and find the macros menu option, but only one of the functions/subs appears. I have had a look at what's different between this sub and the others, and can't find anything that would prevent the others from being shown in this macro menu. The same happens when I go to the VBA IDE and go to the Run menu (F5). I've tried manually typing the function/sub name in the textfield, but when I do, the 'Run' option is greyed out.
Does anyone have any idea how to resolve this?
TIA.

robzyc · August 20th, 2007, 11:08 AM

hi d.lee84 (if thats the year of your DOB, hello from another '84 baby!)

In order for a sub/func to appear in the macros list, it must be public and in a module (not a class).

Hope this helps,

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

d.lee84 · August 21st, 2007, 04:52 AM

Hi there Rob,
Thanks for the reply.
I suspected that it may have been because I hadn't declared the functions/subs public explicitly, and checked that, but regardless of whether I declare them "Public Sub aFunction()" or "Sub aFunction()" the problem remains. Also, I made sure that the code was written within modules and not classes.
Any other ideas?
Thanks.

PS Thanks for the warm welcome... I am indeed of the birth year 1984 :)

robzyc · August 21st, 2007, 05:02 AM

Hi d.lee,

Interesting problem, I cant seem to replicate it at all.

Do you definately have the correction option in the "Macros In:" combobox?
(Press F5 and its at the bottom of the dialog).

If that doesnt help, is there any chance you can post some screenshots or something?

Best Regards,

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

d.lee84 · August 21st, 2007, 06:33 AM

Hi Rob,
I've tried changing that to "All Projects" to no avail.
I can't actually upload files to webspace from work, so a screenshot is quite difficult to send you. Any other ideas?
Thanks.

robzyc · August 21st, 2007, 06:58 AM

Hmmm. Very Odd Indeed!

I cant really think of anything else that would cause this behaviour...

Is the project compiling correctly? I have found that if there are (unnoticed) compile errors, then it
can cause some.. interesting behaviour!

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

d.lee84 · August 21st, 2007, 08:14 AM

Yup I tried compiling it and made sure everything is ok. I just tried out the same on an access MDB frontend file, and found the exact same. I can run the functions through forms that I've designed, but when I try to run them through the menu, they don't appear. I'm thinking it may be a preferences menu option... Anyone ever heard of/encountered such a thing?
Thanks.

robzyc · August 21st, 2007, 08:29 AM

d.lee,

I dont think so.. What version of Access are you using? What are your security settings? Can you post some code from some controls that call the procedures?

Best Regards,

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>

d.lee84 · August 21st, 2007, 08:44 AM

Oh dear... I think I've worked it out. I didn't realise that you could only run subroutines through that menu, and they had to not take any arguments. Just tested this and it works fine.
Thanks for your help though :)

(sorry about being so slow)

robzyc · August 21st, 2007, 09:37 AM

d.lee,

No probs, I should have picked that up really!

Rob
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".
Thomas Jefferson</center>