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.
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
: Microsoft Office Collaborate for free and online versions of Microsoft Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by Micr…