Corrupted ActiveX control? "Can't exit design mode because Control 'DTPicker1" can not be created"

excel vba activexobject
BillD picture BillD · May 17, 2014 · Viewed 26.5k times · Source

I am developing an Excel VBA application on my desktop machine. I have a DatePicker ActiveX control on my spreadsheet. It was working fine.

Then, while on travel, I was working on the application on a laptop. When I returned, I moved the file back to my desktop machine. Now when I try to run the app, I continually get the error "Can't exit design mode because Control 'DTPicker1" can not be created".

Renaming the control and all its references in the code hasn't helped. When I try to delete the control I still get the message even though there is no longer a control of that name.

How do I fix this?

Answer

Jean-François Corbett picture Jean-François Corbett · May 18, 2014

Sounds like something in your workbook got corrupted. Something like this has happened to me once or twice.

The solution is then to copy everything (code and sheet contents) to a new workbook and rebuild your application there.

[Upgraded from comment since this solved the issue.]

Related questions

Excel 2010 ActiveX Controls No Longer Working After Windows Updates

So at work I ran into this issue after I installed the most recent Windows 7 updates (including Microsoft Office 2010 updates) - the date up the update was today (Dec 12, 2014). After the update, I opened my macro enabled workbook in Excel 2010 …

Read More
What event is triggered when user selects value from drop down ComboBox (ActiveX)?

What event is triggered when user selects value from drop down ComboBox (Active X). How it can be defined in VBA. I would like to trigger macro when value is selected from drop down.

Read More
Uncheck all checkboxes across entire workbook via CommandButton

I would like to have a code that unchecks all checkboxes named "CheckBox1" for all sheets across the workbook. My current code unfortunately doesn't work, and I'm not sure why - it only works for the active sheet. Private Sub …

Read More