Can't insert ActiveX objects

[g13392]

Hello,

New to MrExcel. I know my problem is posted in other threads, but I can't seem to find any solution. I have Excel 2007, and I have a workbook with ActiveX checkboxes on the worksheet. I also have a macro that ties the worksheet to see which checkboxes are ticked or not. I was using this file for past year or so, but all of a sudden, I cannot tick the checkboxes. Furthermore, the macro is giving me an error message saying "Object doesn't support this property or method". The workbook is unprotected, in case you may be asking.

I went into Excel Options, Trust Center, Trust Center Settings, and checked the ActiveX and Macro settings, and they are "Enable all controls" and "Enable all macros"), respectively. I've also tried to open new Excel, and insert ActiveX controls, but none of them work. I get "Cannot insert object" error message.

If I take the same file and open with excel 2010, everything seems to work. So I don't think the file is corrupted. I can't seem to figure out what I need to do. If anyone can help me out, I would greatly appreciate it.

Thanks

 

[g13392]

Rory,

Thanks for the link. I deleted all the .exd files, and then followed the add'l step by opening the VBA and modifying. Then I went to Debug>Compile VBAproject. I still can't tick on the ActiveX checkboxes, and none of the macros work.

Any other thoughts?

 

[S13Louis]

I fixed mine by:

Close Excel
Go to C:\Users\<Username>\AppData\Local\Temp\Excel8.0

Then renamed MSForms.exd to MSFormsold.exd

Then open excel.

Worked for me!

 

[RoryA]

Did you close all Office apps before deleting the .exd files, then reboot, then retry the workbooks?

 

[g13392]

To all,

I know new people reading this is seeing the title "Can't insert ActiveX objects" and telling me to delete the .exd files. But just to clarify, I did delete all the .exd files, so inserting an ActiveX object is working now.

My problem is I cannot run macros or tick the current ActiveX checkbox in an existing file. The error message I get when I try to run the macro is "Object doesn't support this property or method". On this error message, if I click on debug, it links to the yellow highlighted line "Sheets("Sheet1").CheckBox1.Value = False" in <acronym title="visual basic for applications">VBA</acronym>.

 

[Andrew Poulsom]

Did you also perform this step?

Additional step:
If the steps above do not resolve your issue, another step that can be tested (see warning below):
1. On a fully updated machine and after removing the .exd files, open the file in Excel with edit permissions.
Open Visual Basic for Applications > modify the project by adding a comment or edit of some kind to any code module > Debug > Compile VBAProject.
Save and reopen the file. Test for resolution. If resolved, provide this updated project to additional users.

 

[g13392]

Andrew,

I performed the additional step mentioned. Still does not work.

 

[pedrowave]

These are the problematic updates:

• Security Update for Microsoft Office 2007 (KB2596927)

• Security Update for Microsoft Office 2010 (KB2553154)

• Security Update for Microsoft Office 2013 (KB2726958)

Uninstall the relevant one and you will be fine.
To avoid future re-installation it may be necessary to make changes in your Windows Update settings.

 

[Andrew Poulsom]

These are the problematic updates:

• Security Update for Microsoft Office 2007 (KB2596927)

• Security Update for Microsoft Office 2010 (KB2553154)

• Security Update for Microsoft Office 2013 (KB2726958)

Uninstall the relevant one and you will be fine.
To avoid future re-installation it may be necessary to make changes in your Windows Update settings.

It seems we all have "specially crafted" workbooks.

 

[g13392]

Pedrowave,

I'm running MSoffice 2007, and I don't see the update "Security Update for Microsoft Office 2007 (KB2596927)".

 

[Andrew Poulsom]

In Control Panel|Programs|Programs & Features|Installed Updates I have it under 'Microsoft Office Ultimate 2007'. Don't you see it under your version of Office?