Can't exit Design Mode issue

[nuc_n_futs]

I am having an issue with Visual Basic, I keep getting an error message, "Can't exit design mode because Control 'Command Button11' cannot be created' when I try to exit Design Mode.

when viewing the code, I click on the drop down menu where all the command buttons are stored in the Visual basic Editor and there is a CommandButton11 (as well as another 40 Command Buttons) that for the life of me, I cannot find them anywhere on my spreadsheet.

Is there any way I can delete these CommandButtons out of the drop down menu? If so, how?

If not, is there another work around so I can finally Exit Design Mode, such as putting in ficticious code that will do absolutely nothing but remove the error.

I really don't want to have to create this sheet over again.

Thank you,

Ron

 

[rlm1111]

FWIW, I opened my .xlsm spreadsheet after installing Windows 10, and it seemed to be stuck in design mode, when I tried to click on any command button. Turns out it wasn't in design mode, it's just that each button had lost it's link to a macro. I rightclicked each button and reassigned the macros. That fixed my problems.

 

[bisel]

I know this is an old thread, but I am recently getting this error.

One thing I tried and it seems to be working is to one of the following:

1. Do not open any other instance of Excel that may have command buttons and what not. Open only the workbook in question.
2. Name your command buttons and other items (e.g., combo boxes, text boxes, etc.) a unique name to any other macro enabled workbooks.

Best regards,

Steve Bisel