Results 1 to 6 of 6

Some controls not working after Windows update.

This is a discussion on Some controls not working after Windows update. within the Excel Questions forums, part of the Question Forums category; Hi Folks I've not had to ask a question for a very long time - but have a problem: I've ...

  1. #1
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,325

    Default Some controls not working after Windows update.

    Hi Folks
    I've not had to ask a question for a very long time - but have a problem:

    I've just completed the most recent Windows update, and now many of my ActiveX controls don't work.

    Controls on userforms still work, and I can add new ones, but those on spreadsheets are visible, but don't even allow themselves to be pressed. If I try to add a new control to a spreadsheet, I get an error message "Cannot insert object."

    If any code runs which refers to these controls, I get the error message "Method or data member not found."

    It's as if ActiveX controls on spreadsheets are not recognised any more.

    Can anyone shed any light?

    I was wondering if the reference to the appropriate library is missing, perhaps?

    EDIT: Windows Vista, Office 2007.
    Last edited by sykes; Dec 14th, 2014 at 10:25 AM. Reason: Windows/Office versions
    Sykes
    Windows 10 / XL 2016

  2. #2
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,105

    Default Re: Some controls not working after Windows update.

    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  3. #3
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,325

    Default Re: Some controls not working after Windows update.

    Hi Mark
    Thanks for the quick response.

    That looked hopeful, but having followed the instructions, and deleted all of the .exd files, the symptoms still exist.
    Sykes
    Windows 10 / XL 2016

  4. #4
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,105

    Default Re: Some controls not working after Windows update.

    Can you just list the folders you checked for the .xld files and did you close and restart excel?
    Are you using Excel 2013?
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

  5. #5
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,325

    Default Re: Some controls not working after Windows update.

    Mark

    I just repeated the exercise, and deleted the files from the Recycle bin as well, and that was successful.

    This page helped describe things a little better as well:

    Office Update breaks ActiveX controls | Excel Matters

    Even when the first attempt didn't work, at least it was good to know that it wasn't a problem with my code or workbook, but rather something that had been caused by the recent update.

    Thanks again for your help.
    Sykes
    Windows 10 / XL 2016

  6. #6
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    8,105

    Default Re: Some controls not working after Windows update.

    Yes I've seen both links and some get on better with one and some with the other (and seen a few others as well). Think I will post both if needed in future

    Glad you got it sorted (and hopefully Microsoft might supply a patch soon).
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, Excel jeanie, RoryA addin (Win & Mac) or Borders-Copy-Paste

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