Assigning Macro to a button not working but works when run manually

[AnneWeber]

Hello,

I recorded a macro just clearing inputs in my file that I'm working with and I've inserted a button onto the sheet and done the 'assign macro' step but it doesn't run my macro. I'm not getting any error or anything, the button does nothing. The macro works if run it from the 'View Macro' option on the ribbon but I can't get it to be assigned to the button. I've tried both a button and a shape. I've gotten it to work if I am assigning the macro to the button and titling it 'Workbook name YYYY.xlsm'!Clear (clear is what my macro name is) but if I do it this way and I make edits in the future and rename the workbook, I'm worried the button won't work.

 

[Joe4]

Welcome to the Board!

Does this VBA code reside in the workbook you are trying to run it in, or somewhere else?

What is the name of the module it is stored in?

Can you post the VBA code for this procedure?
See here for how to post your VBA code: How to Post Your VBA Code

 

[Skyybot]

Alt-F11 to open VBA project. Click the Sheet in the VBA project model that the Button is on. Top left of the Code window use the drop-down and click on the Button name. Paste code for button there.