Can't insert ActiveX objects

g13392

New Member
Joined
Dec 11, 2014
Messages
8
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
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

g13392

New Member
Joined
Dec 11, 2014
Messages
8
Rick and Smitty,

Thanks for your quick reply. I followed the directions from the links you guys sent, and deleted the MSForms.exd, so now inserting activeX objects work. However, the original file still does not work. I cannot tick/untick the checkboxes, and the macro still gives me the error message saying "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 VBA.

Further insight to this issue would be greatly appreciated.
 

g13392

New Member
Joined
Dec 11, 2014
Messages
8
Smitty,

The link takes me to a Microsoft account. I enter my user ID and password, but it's not letting me access it. I tried changing pw, but still doesn't work. Any other thoughts? If you can access the text, can you post it here?

Thanks
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,793
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
I guess not everywhere has effective moderators... :biggrin:
 

Er_ImranShaikh

New Member
Joined
Nov 24, 2014
Messages
2
1.Close Your Excel 2. Goto C Drive 3. Search for *.exd Files 4. Delete all .exd files. 5. start Excel again it will solve Your ActiveX Object and "cannot insert object" problem
 

Watch MrExcel Video

Forum statistics

Threads
1,095,148
Messages
5,442,656
Members
405,191
Latest member
wedloski

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top