Activex Combobox - VBA Code not running

[eoinymc]

Hi there,

Just wondering if anyone can help me.

I have an excel report that uses activex comboboxes and triggers VBA when they are changed.

The issue I have is that since MS rolled out an update earlier in the year, the report runs fine on some of the machines in my organisation, but doesn't on others...

Does anyone know of any setting or anything like that that I can change to see if it works? Or are there any temp files to be deleted or anything at all...it really is a hindrance for me at the moment as the report was used extensively for decision making around the org.

Thanks in advance,

E

 

[RoryA]

Have a read of this: Office Update breaks ActiveX controls | Excel Matters

 

[ranman256]

Is EVERYONE using the same version of Excel?

 

[eoinymc]

Have a read of this: Office Update breaks ActiveX controls | Excel Matters

Thanks, but when I try to install the fix for that, it says that no office products are installed for this fix!

I'm at a loss here....my head is officially wrecked!

 

[RoryA]

Which fix are you trying to run and which version do you have? You can simply delete the .exd files yourself if all else fails, but you do have to do it on all the machines. Better still, replace the activex with Form controls or data validation dropdowns. ActiveX controls on worksheets have always been unstable.

 

[Colin Legg]

If the problematic update was only rolled out on some machines then, if a user on one of those machines saves a workbook, users on machines without the update won't be able to use that workbook.

So basically, if all machines have the update, then you should be able to run the fix Rory suggested on all machines and then all will be OK.
If only some machines have the update then the fix won't be any good. You'll need to replace the ActiveX controls with Forms controls (as Rory suggested too). The caveat is that, if a workbook was last saved by a user with the update installed, the ActiveX controls in that workbook can only be deleted by a user on a machine where the update is installed.

I don't know if I explained that particularly well; I blogged a more verbose version here.

 

[eoinymc]

Which fix are you trying to run and which version do you have? You can simply delete the .exd files yourself if all else fails, but you do have to do it on all the machines. Better still, replace the activex with Form controls or data validation dropdowns. ActiveX controls on worksheets have always been unstable.

I have already deleted the .exd files on these machines, but it still won't work...

I'll just re-engineer the report to use form controls as you have said...I just didn't want to have to do this as it is quite a large report and are a lot of triggers.

Thanks