Some controls not working after Windows update.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,885
Office Version
  1. 365
Platform
  1. Windows
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:

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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.
 
Upvote 0
Can you just list the folders you checked for the .xld files and did you close and restart excel?
Are you using Excel 2013?
 
Upvote 0
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.
 
Upvote 0
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 :biggrin:

Glad you got it sorted (and hopefully Microsoft might supply a patch soon).
 
Upvote 0

Forum statistics

Threads
1,212,931
Messages
6,110,745
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top