up vote 0 down vote favorite
share [g+] share [fb]

I used the macro recorder to generate a macro in Excel 2007. When I try to the run the macro, it tells me:

Compile error: Sub or Function not defined

When I click Ok the definition of the macro gets highlighted.

enter image description here

I'm really confused about why VBA would throw this error. I just defined it! Do you have any ideas what I did wrong?

link|improve this question
67% accept rate
feedback

2 Answers

up vote 1 down vote accepted
  • 1st - check if there's no missing reference in the VBA project.
  • 2nd - It seems it needs the Solver Addin. Ensure it's checked in Excel Addins.
link|improve this answer
I'll check this out. I didn't think about references. Hopefully that is it. Thanks. – wdkrnls Mar 30 '11 at 6:58
You were right. I didn't add Solver to the references for the project. Thanks. – wdkrnls Mar 31 '11 at 20:55
feedback
up vote 0 down vote

I had the same problem.

I copied my code and created another module. Right clicking Module1 in the Project Tree, I used the "Module1 properties" to change the name of the module to 'Day_Muster' (the name of my sub), but left the name Module1 alone (huh?).

Now when I hit alt-f8 in Outlook, I get the option to run 'Day_Muster'. I click an everything is good!

Hope this helps somebody.

link|improve this answer
Do you know what this does when you do it? – Raystafarian Mar 7 at 14:29
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.