I have several command buttons a worksheet that activate their on-click event (_Click) when clicked. These have worked for several years and then all of a sudden they no longer work. And more so, the VBA errors with "Variable not defined" when the workbook is opened event though when I go into design mode I see the controls name and when I double click it it displays the _Click() VBA code for the sheet.
I've brought back archived versions and they now also react this way. I was thinking this might have been some setting changed in my Excel options but this behavior occurs on both my home and work versions of Excel (2010 at home and 2007 at work).
What is happening?