excel active x control button is not working suddenly

excel activex excel-2013
user2958279 picture user2958279 · Dec 11, 2014 · Viewed 70k times · Source

I'm working with excel macro-enabled files,

Today I just found out the button i made was not working-cannot be click- which was working yesterday. And digging up the matter, I found out that other Activce X controls is not working also, and I cannot event insert Activce X controls.

when i try to insert Activce X controls (just normal basic button) excel give me "Cannot insert object" message box.

And It's same with my colleague's computer. Is only us having this problem today? and was there had any MS-updates related to this issue yesterday?

Answer

user2958279 picture user2958279 · Dec 12, 2014

https://social.technet.microsoft.com/Forums/office/en-US/94d0b004-3303-421d-9ed2-351683b89d08/sudden-problems-with-inserting-activex-basic-controls-such-as-command-buttons?forum=officeitproprevious

found out the solution.

Quit Excel. Start Windows Explorer. Select the system drive (usually C:). Use the Search box to search for *.exd Delete all found files.

(Thanks to Excel MVP RoryA for this tip) Regards, Hans Vogelaar (http://www.eileenslounge.com)

Related questions

Microsoft Excel ActiveX Controls Disabled?

I have some Excel worksheets that use ActiveX checkboxes to control certain activity. They worked recently but today started to give errors. I was alerted to this by a colleague, but it was still working on my computer. I checked …

Read More
What is the difference between "Form Controls" and "ActiveX Control" in Excel 2010?

Using Microsoft Excel 2010, I noticed two kind of controls that can be inserted into a document: Form Controls and ActiveX Controls. What is the difference between them?

Read More
"Cannot insert object" error when adding ActiveX control like Microsoft DataGrid to Excel sheet

One of the users of our iGrid ActiveX grid control needs to insert it directly into an MS Excel sheet, but they have not managed to do that - the "Cannot insert object" error is generated all the time. We …

Read More