MS Excel Error - Cannot run the macro "***". The macros may not be available in this workbook or all macros may be disabled.

Question

I have a workbook that I am getting this error in everytime I try and click a button. I have tried creating a new button and I get the same error.

Also, I have another workbook just like this one but for the previous years data and those buttons work perfect. It is the same code and everything. What can I try? Ideas?

Answer 1

Hi asnoble, what is the exact error you are getting?

You could try debugging the Macro:

On the Tools menu, point to Macro, and then click Macros

Click the macro, and then click Step Into.

When you click Step Into, the Visual Basic Editor opens with the first line of code in the macro highlighted and with program execution halted.

Press F8 in the Editor to execute the first line of code and step to the next

Repeat this procedure until you find the line of code that is causing the error, then try to logically work out why it is happening . . .

Answer 2

It never makes it to the code. I tried to debug but the error just flashed up.

See above for error. This happens on brand new buttons. I even created a button for Hello World and it never made it to the code.

All Macros are enabled through Trust Center. And again, my other workbook works.

Hi asnoble, what is the exact error you are getting?

You could try debugging the Macro:

On the Tools menu, point to Macro, and then click Macros

Click the macro, and then click Step Into.

When you click Step Into, the Visual Basic Editor opens with the first line of code in the macro highlighted and with program execution halted.

Press F8 in the Editor to execute the first line of code and step to the next

Repeat this procedure until you find the line of code that is causing the error, then try to logically work out why it is happening . . .

Answer 3

Hi asnoble, your last post did not come through, could you please post that again . . .

Answer 4

Try to recompile the complete VBA project, do as follows:

Open the VBA editor

Go into each module

Insert a line (doesn't matter what you write)

Press ENTER

Remove the line that you've inserted

When finished, in the menu click Debug \ Compile

It sounds silly to do that, but it's the only way to force the compiler to rebuild any code.

Andreas.

Answer 5

It never makes it to the code. I tried to debug but the error just flashed up.

See above for error. This happens on brand new buttons. I even created a button for Hello World and it never made it to the code.

All Macros are enabled through Trust Center. And again, my other workbook works.

Hi asnoble, what is the exact error you are getting?

You could try debugging the Macro:

On the Tools menu, point to Macro, and then click Macros

Click the macro, and then click Step Into.

When you click Step Into, the Visual Basic Editor opens with the first line of code in the macro highlighted and with program execution halted.

Press F8 in the Editor to execute the first line of code and step to the next

Repeat this procedure until you find the line of code that is causing the error, then try to logically work out why it is happening . . .