I'm creating an Excel 2010 workbook with an Active X control button inserted on a sheet. Except the button doesn't work. I'm not doing anything I haven't done before and the VBA procedure works fine if I use the Ctrl-Shift keys to run the macro.
I believe a Windows 7 update may have affected how Active X controls function. Is this true ?
Any ideas how I can get round this issue ?