Command button not working and can't add new buttons to workbook
Posted on 2014-12-11
I created a workbook that has a command button ActiveX control on a sheet to show a userform. The userform in turn has several controls. All of this was working fine yesterday.
When I opened the workbook this morning, the command button that displays the form did not respond and I cannot add new activeX controls to the sheet (I get an error message saying "Cannot insert object". This also happens if I open a new workbook and try to insert an activeX control.
However, if I insert a windows forms control and assign a macro to it to show the form, it works perfectly - I can even add new activex controls to the userform and they do what they are supposed to.
The sheets and workbook are not protected and macros have been enabled.
I've tried closing and reopening Excel, shutting down and restarting the computer, etc. but I still have the issue with activeX controls in worksheets.
How can it be fine yesterday and suddenly not work today?
Any help would be greatly appreciated.