We have a macro-enabled template which has been working fine on all machines in the office for ages. Recently, on certain machines only, it has produced "Run-time error 1004: Unable to get the Object property of the OLEObject class."
It works on one machine with Windows 7 Professional installed running the Home & Business 2013 version of Excel. It does not work on another Windows 7 Pro machine running the Professional Plus 2013 version of Excel.
The code which seems to be producing the error:
I have tried referencing the OLEObjects by their index numbers instead of as a collection. This produces another error (not the same error as before). I have tried activating each OLEObject prior to retrieving its properties; another error code. I have tried adjusting the security settings in many different ways with no luck.
Does anyone have any idea what went wrong?
(Just in case, here is the ITEM_COMBOBOXES class)