Enabling Macros

**ggordonstewart** · 02-11-2010, 03:47 AM

I recently reformatted my hard drive. When I re-installed Office 2007, I was unable to run a Workbook that has a Macro in it. First, I went to Add-ins and added the Solveradd-in. When I opened the workbook, I enabled Macros. However, all I get is a maessage saying that the MVB did not compile. I know there are some things you have to do to solve this, but I cannot remember the procedure I went thru 2 years ago to get this to work. Does anyone know what steps I must take?

**teylyn** · 02-11-2010, 04:45 AM

a maessage saying that the MVB did not compile

can you post the exact error message?

**ggordonstewart** · 02-11-2010, 04:59 AM

Micosoft Visual Basic
Compile error:
Sub or Function not defined.
On the Module1 (Code), the following:

Please Login or Register  to view this content.

**teylyn** · 02-11-2010, 05:45 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I'll add the code tags for you this time, but I'll expect you to use them from now on.

What line does the error occur on? Whatever happened to the "MVB did not compile" error you listed in your first post? Where does that come in?

Can you state exactly what error you get and which line it occurs on?

**DonkeyOte** · 02-11-2010, 05:47 AM

You will need to set a Reference to Solver in VBE, see: http://peltiertech.com/Excel/SolverVBA.html

**ggordonstewart** · 02-11-2010, 11:05 AM

Is there a way to attach the file i AM TRYING TO RUN?

**teylyn** · 02-11-2010, 04:06 PM

You can upload a file by clicking "Go Advanced" below the Quick Reply box and then the paper clip icon.

**ggordonstewart** · 02-11-2010, 10:03 PM

This is the file I am trying to run. When I run it, it goes to a page that shows the Module1 Code that I copied and posted previously. It also has a small box that contains the information I showed at the top of the last post. It reads"Microsoft Visual Basic Compile error: Sub or Function not defined. New dehycalc1.xlsm-Module1(Code)"

**ggordonstewart** · 02-12-2010, 12:02 AM

Even though the article you referenced was for the older versions of Excel, I was able to figure out what to do in Excel 2007. There is no "Tool" Menu in 2007. Instead, you go to the Logo Button in the top left and click the Excell Options Button. Then you go to Add-ins and add Solver.
You then need to activate Microsoft Visual Basic and follow the rest of your directions. I got to MVB by Editting the Macro.
Thanks for the help. The problem is solved.