Cannot create add Active X Command Button to worksheet
Posted on 2015-01-08
I have created an Excel xlsm workbook using Excel version 2007 with a command button that calls a form to display on the screen for the user.
When the user opens the same workbook using Excel 2010, the command button does not work. When I right click on the Command Button there is no VBA code attached to the button. In addition, when I try to add another command button to the worksheet, I get an error that the Object Cannot be Created.
The Microsoft ActiveX Data Objects 2.8 Library is checked.
What do I need to do to allow this object to work?