I have a .xlsm file that has ActiveX control button with a module macro assigned to it. Problem is I can't click the ActiveX button from my Excel 2010 Standard. I tried to repair and reinstall Excel but that did not fix it. Tried adding a new ActiveX control to the worksheet but got "Cannot insert object" message. Any idea what's is going on?
UPDATE:
I checked as many of the security settings as I could based off Google searches, but that didn't seem to work. The icon of the excel file does have a ! sign on orange background though.
SOLUTION:
Uninstallting latest Microsoft Office updates solved the issue. I was uninstallting Office updates 1 by 1 until I uninstalled a big one - Service Pack 2 for Office. After a required restart the ActiveX button started to work. Thank you, ajs.
Answer
The latest Windows update killed it. Back out the ones involving Excel and VBA and it will run again.
No comments:
Post a Comment