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.