Page 1 of 3 123 LastLast
Results 1 to 10 of 30

Can't insert ActiveX objects

This is a discussion on Can't insert ActiveX objects within the Excel Questions forums, part of the Question Forums category; Hello, New to MrExcel. I know my problem is posted in other threads, but I can't seem to find any ...

  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    8

    Default Can't insert ActiveX objects

    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

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,435

    Default Re: Can't insert ActiveX objects

    Welcome to the Board!

    The most recent Office update breaks ActiveX controls, and believe me, Microsoft has been hearing all about it!

    For a fix see: Office Update breaks ActiveX controls | Excel Matters

    Hopefully, Microsoft will get it resolved shortly.

    HTH,
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  3. #3
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    28,550

    Default Re: Can't insert ActiveX objects

    This may be your problem and its solution...

    Office Update breaks ActiveX controls | Excel Matters
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  4. #4
    New Member
    Join Date
    Dec 2014
    Posts
    8

    Default Re: Can't insert ActiveX objects

    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.

  5. #5
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,435

    Default Re: Can't insert ActiveX objects

    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  6. #6
    New Member
    Join Date
    Dec 2014
    Posts
    8

    Default Re: Can't insert ActiveX objects

    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

  7. #7

  8. #8
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092

    Default Re: Can't insert ActiveX objects

    Ah, the one with the spam in the comments.
    Microsoft MVP - Excel

  9. #9
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    29,785

    Default Re: Can't insert ActiveX objects

    I guess not everywhere has effective moderators...

  10. #10
    New Member
    Join Date
    Nov 2014
    Location
    Mumbai(India), KSA,UAE
    Posts
    2

    Default Re: Can't insert ActiveX objects

    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

Page 1 of 3 123 LastLast

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com