I can't assign a macro to a button.

[dragontbone]

I have a macro that I want to assign to a button, but when I right-click>assign macro, the name of the macro won't show on the list. I have macros enabled in the trust center, and, this is the only workbook open. I can see the macro in the VBA editor, and it is under the right module in the correct VBA project. I have tried to close Excel, then re-opening it, re-starting my computer, and disabling then re-enabling macros in the trust center. I am not sure what else I can do.

 

[Joe4]

Is the button a Form Control button or on ActiveX Control button?

Can you post the first row of the procedure you are trying to assign the button (the one that contains the name and any parameters)?

And you can tell us the name of the VBA module the procedure resides in?

Also make sure that you have the "Macros in:" option set properly, to include the workbook that the procedure resides in:

 

[dragontbone]

Is the button a Form Control button or on ActiveX Control button?

Can you post the first row of the procedure you are trying to assign the button (the one that contains the name and any parameters)?

And you can tell us the name of the VBA module the procedure resides in?

Also make sure that you have the "Macros in:" option set properly, to include the workbook that the procedure resides in:
View attachment 100572

I have only ever used form control buttons as I am unsure how to assign a macro to the activex buttons. I also made a shape and tried to assign a macro and was unable to assign a macro to it as well if that helps.

Here are screenshots of what I am seeing both in the assign macro pop up box, and the VBA code editor:

 

[Joe4]

Have a look here: MACRO'S HAVE DISAPPEARED BUT ARE STILL IN VBA

If none of this helps, you may have a corrupted workbook. In that case, you may need to create a new workbook, and copy all your VBA code to that and use that instead.

 

[dragontbone]

Have a look here: MACRO'S HAVE DISAPPEARED BUT ARE STILL IN VBA

If none of this helps, you may have a corrupted workbook. In that case, you may need to create a new workbook, and copy all your VBA code to that and use that instead.

Thanks for the link. It gave me the idea to try to compile the file. I have no idea why that worked, but thank you!

 

[Joe4]

Excellent!
Glad to here you got it fixed, and thank you for posting back how you were able to resolve it.