The form buttons and controls on all my worksheets suddenly stopped working. The behavior is like what you see before you respond to the security prompt-- "enable macros?", that is, when you mouse-over a control button the mouse icon doesn't morph into an arrow. Even when I manually check the "Enable macros" box on the options page the problem persists. When I run the same .xlsm file on my laptop it works fine so it doesn't seem to be the fault of the my project software. The Microsoft Help Center says that under my license the two computers running Excel simultaneously should have full VB development capabilities. Any ideas?
One of the automatically installed patches for Office may have created this issue for you
Check to see if the following may apply Three symptoms are described but the third may be what you are seeing
a Microsoft Excel workbook that includes ActiveX control (forms3) on a computer that has MS14-082 installed, the Excel macro may not work on computers that do not have MS14-082 installed.