Hello,

In my company we have several PCs running Windows8.1 with either Office 2010 or 2013.

We use multiple Excel files with ActiveX buttons on the spreadsheet to activate Macros that mainly import data from .txt files.
Without any major problems with our current setup(all day, daily, for approx 6 months now)

Today, one of the PCs (W8.1, Excel2013) suddenly did not recognize the ActiveX buttons on the spreadsheet as buttons. I just can't click on them anymore, they seem frozen.
The macro itself that the button is linked to, works.
If I try to add an ActiveX CommandButton, I get an error:
"Cannot insert Object".
However, the FormButtons still work, and I can add more of them.
This problem occurs with any excel file. That is the case even when I make a completely new book.

I tried setting the Macro and ActiveX safety settings to the lowest in [File-Option-Security Center Settings-(ActiveX/Macro Settings)]
But no change.
I am not in Design mode. (If I go into design mode, I can select the buttons, and with a double click I can open the Code editor. However, the cursor does not jump to the part of the code it should jump to, and I can also not see the properties with a right click on the button -it shows the properties of the sheet instead)

A few hours later, the next PC (W8.1, Excel2010) stopped working. Exactly the same issue. And this PC did not open a file the first PC had opened or created...

2 out of 5 PCs stopped working, the last 3 still work.
I tried reproducing the problem with one of the working PCs, but I couldn't.

I couldn't find a thread anywhere with someone having the same issue, so I made one myself.


Do you have any suggestions????

It's frustrating me...
Thank you so much for your help!

I'm having the same issue. I think it's related to the Microsoft patches last night. Have every user in my firm unable to use their buttons in Excel. An easy test is to start a new workbook, then click Insert on the Developer tab, choose the button control under ActiveX controls, and try and draw it on the sheet. Get the error "Cannot insert object" immediately. This is really really bad. Our whole firm is unable to use their programmatic worksheets.

Thanks Microsoft!

Anyone have a fix?

I am having the exact same problem, been doing a lot of alterations to our work program just recently and thought I'd done something wrong. Relieved it isn't just me, but that doesn't really help. Please Microsoft get this fixed soon!

We have some Excel files with ActiveX components on the spreadsheet to activate Macros. They worked well until the last windows update. The same file works in PCs that aren't update yet.

HELP!

Hi Guys,

I believe I may have narrowed it down to the patch KB2596927. The details are here: http://www.microsoft.com/en-us/downl....aspx?id=45206

I removed the patch in Control Panel, Programs, Uninstall, View Installed Updates on the left.

I've only tried it on one affected PC so far but it's working in Excel now with the ActiveX controls.

I have managed a temporary fix by using System Restore to take my PC back to yesterday, before I installed the latest updates. Need to find out which one caused the problem, could well be the one mentioned in the post above.

Thanks, removing that patch worked for me.

Wow!
I'm glad I'm not the only one with this problem!!

I'll try your suggestions and keep you updated with the result!
I hope Microsoft comes up with a better update soon!

Hi there,

I did the System Restore to the day before the update.
That worked at first, but then it somehow stopped working again, so I put it back to the latest version, then back to the old version. Now it's working again.

I'm happy it's working again, but I'm worried it will stop working again...

This worked on one PC, but not on another! I coudn't do the restore at all. I got an error that the restore was aborted.

So I also tried the the other option with deleting the patch: KB2596927
But I wasn't able to find it in the list...?

How can I find out which patch is the right one?
Delete one after another(of the ones that were updated) until it works??

Maybe this is a question I should ask in a different thread but while we're at it, I thought I can ask it here in the context...

Thank you for the help!

I got it!

Excel 2007: delete KB2596927
Excel 2010: delete KB2553154
Excel 2013: delete KB2726958

Now I hope that Microsoft Programmers read this thread or notice this problem themselves!

Thank you for the help everyone!

Unlikely. As plainly stated at the foot of every forum page on this site:

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]