Form Control Button Doesn't Work but ActiveX Does

[aknorth]

I have an excel file where no created Form Control Buttons workS, the following error is provided
"Cannot run the macro. The macro may not be available in this workbook or all macros may be disabled"

However if I create an ActiveX button using the same macro and name it runs just fine

I will go ahead and use the ActiveX button to get around this problem but it would be helpful to figure out why this is occurring
Thanks for the help

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Kyle123]

How have you assigned the macro to the button?

 

[Fluff]

IT should be in a module and the sub declared as public.

Judging from the image, that's exactly what the OP has done.

 

[Kyle123]

haha yes, I realised after I typed that and changed the post!

 

[Domenic]

Can you confirm where your macro for your form control is located? If it's in fact located in the code module for your sheet, you'll need to assign your macro in the following format . . .

Book1.xlsx!Sheet11.TESTBUTTON_Click