Excel Control Linked to NonExistent Macro - Cannot Unlink

Question

I created a sheet with a checkbox and accidentally click "Assign Macro". VBA Editor opened and the macro was automagically called sub <control name>OnClick(). Having made this macro by mistake, I deleted the lines of code from VBA Editor and saved the project. I also made sure that the macro name does not appear in any of the macro dialogues - I specifically clicked the macro in the Macros dialog and then clicked 'Delete' hoping that Excel would properly handle unlinking the macro from the checkbox control.

Unfortunately, when I click the checkbox, it still is linked to the macro... even though the macro no longer exists. There appears to be no way to unlink this control from the macro post-facto. To get the following error message to go away, it seems I will need to remake all of the hundreds of checkboxes from scratch.

Error: Cannot run the macro 'working_example.xlsx!CheckBox11_Click'. The macro may not be available in this workbook or all macros have been disabled.

Please let me know how to fix this issue without redoing all the tedium. Maybe I can edit the XML directly or something. Please... i just don't want to have to redo hundreds of checkboxes because Excel can't keep it's sh** together.

Answer 1

If you send me a copy of the workbook, referencing this thread in the covering email message, I will investigate the issue.