I have a fairly large application using an Excel 2007 spreadsheet on Windows 7.
I have a number of Active X Control Command Buttons which run VBA code. It has all worked for some time.
Today I find none of the command buttons work.
When I go into Design Mode I can highlight the buttons but when I click view code the VBA window comes up but at the top of the code not at the code for the button I have pressed. Also when I RH click properties for the button I get the properties for the sheet no t for the button. I tried making a new button and adding some code to it and it works fine.
i can run the code from the VBA window using F8. The spreadsheet runs fine on my laptop and everything works.
I tried reloading Excel but no change. It seems that the buttons are behaving like a graphic and are not triggering the code.