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

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.

Tried that, and hit compile and still is doing it.

Answer 2

Hi Asnoble,

Thanks for the screenshot, 2 things to check:

1.

Press Alt + F11 to open the VBA Editor

Does a Macro called CommandButton1_Click exist?

If not or your Macro has a different name, name it CommandButton1_Click

Close the VBA Editor

2.

Go to File - Options

Go to Trust Center - Trust Center Settings - Macro Settings

Set Macro Settings to 'Enable all Macros'

Save and Exit Options

Does the Macro then run?

Answer 3

Hi Asnoble,

Thanks for the screenshot, 2 things to check:

1.

Press Alt + F11 to open the VBA Editor

Does a Macro called CommandButton1_Click exist?

If not or your Macro has a different name, name it CommandButton1_Click

Close the VBA Editor

2.

Go to File - Options

Go to Trust Center - Trust Center Settings - Macro Settings

Set Macro Settings to 'Enable all Macros'

Save and Exit Options

Does the Macro then run?

Yes, does exists. I have a messagebox behind it for this test.

Enable All Macros is checked with Radio Button.

Answer 4

On the same settings page, check the box marked 'Trust access to the VBA project object model'

Save the settings changes

Close Excel and start it again, then try running your macro - does it run?

Answer 5

On the same settings page, check the box marked 'Trust access to the VBA project object model'

Save the settings changes

Close Excel and start it again, then try running your macro - does it run?

Box is already checked