BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 29 January 2015
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
"Cannot insert object" when adding ActiveX Control in Excel
A short blog to help others suffering from the same affliction! So you're using Excel (perhaps running a training course ...), and you try to insert an ActiveX command button:
Whether you should be using Form controls instead is another question!
Excel then greets you with this error message:
A not-that-helpful error message!
The reason this happens is because of a Microsoft security update - you can find more details here.
I suspect that this happens only when you're running different versions of Excel on the same computer.
The web page given above lists various solutions. One that worked for one Wise Owl is to run a disk clean up:
How to find the disk cleanup utility in Windows 7, for example.
However, this didn't work for me - and nor did repairing Office 2010, or running any of the automatic Microsoft fixes listed on the webpage linked to above.
What worked for me
As so often it was StackOverflow which provided the answer (specifically this page), which was to delete this file in the folder:
C: \ Users \ [your user name here] \ AppData \ Local \ Temp \ Excel8.0
as shown here:
Find and delete this file in your user profile folder.
This finally did the trick!