ActiveX Option Button Control

[smarie123]

I created a workbook several weeks ago that was working beautifully until I got on it today and noticed none of the option button controls were working. When I go to properties to try and figure it out the properties don't even look the same. I had originally had to create a group of buttons that were all on the same row and name them all the same name (within the properties function) in order for Excel to recognize that within that group of buttons only 1 should be clicked at a time and have several rows of buttons that all buttons on a certain row have the same grouping. Like I said, it worked beautifully. Now, all of a sudden, the buttons don't even allow me to click them, the properties feature doesn't even give me the option to enter a "group name" anymore, and I also can't enter any more ActiveX Controls even if I wanted to because the error message "cannot insert object" pops up. I've googled the issue several times already and can't seem to understand what people are suggesting to change. Can anyone PLEASE help me!!!!!!

 

[Andrew Poulsom]

Are you using Click-To-Run? If so look here:

"Cannot insert object" error in an ActiveX custom Office solution after you install the MS14-082 security update

 

[jeffmb]

I have searched my PC and cannot find any *.exd files anywhere. Any suggestions?

 

[Andrew Poulsom]

Have you enabled the option to 'Show hidden files, folders, and drives' in Windows Explorer?

 

[smarie123]

Yes, and I've searched up and down the code attached with the version updates and I don't have any of the referenced codes. I'm stuck...I can't ix my existing worksheets and I can't make new worksheets even if I wanted to. This is ridiculous!!

 

[smarie123]

Yes and I'm looking for every code that they saying is associated with the updates and none of those codes exist in my recent updates. I'm totally stuck. I can't fix my existing worksheets and I can't make new ones even if I wanted to. This is ridiculous!!

 

[Andrew Poulsom]

My question was addressed to jeffmb.

 

[smarie123]

I'm sorry. I keep replaying to a thread that I have but it keeps posting to this one. Not sure why!

 

[jeffmb]

I verified that "show hidden files, folders, and drives" was checked and searched again. This time I found and deleted these files. Excel is working again. Thanks for your help.

 

[smarie123]

IT FINALLY WORKED!!!!!!!!!!!!!!!!!!!! After about a month of pulling my hair out my IT guy suggested an online repair of Microsoft Office...that ALONE did not work but once I did that THEN deleted the TEMP files AGAIN it FINALLY works!!!!!!!!!

 

[Andrew Poulsom]

IT FINALLY WORKED!!!!!!!!!!!!!!!!!!!! After about a month of pulling my hair out my IT guy suggested an online repair of Microsoft Office...that ALONE did not work but once I did that THEN deleted the TEMP files AGAIN it FINALLY works!!!!!!!!!

Thanks for posting your solution.