Excel2007 Control Buttons have become inactive

lokimad72

New Member
Joined
Dec 16, 2014
Messages
1
We have an Excel sheet that we've been using for over a decade to generate programs for us. Suddenly on Monday the two buttons to initialize and serialize on the sheet became inactive. The cursor does change to an arrow when move over the buttons, but the buttons do not depress and there is not reaction to clicking on them. I set the Macro Security level to low and set ActiveX controls to enable everything. The curious thing is that it suddenly stopped working for 3 of the 4 user profiles on the computer. So, yes, under one user profile, everything still works (same sheet, same macros). So, I'm trying to figure out if there is something that I'm missing. The sheet was working fine until Monday. I'm not aware of any updates or other activities that may have corrupted anything, evenso, the fact that it still works on one user profile is perplexing to me. I tried installing everything on another computer, but ran into the same issue, oddly enough.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
See the links at the start of my signature block.
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top