Macros are disabled and I cannot enable them

[Singyt]

At work, the majority of our computers have suddenly lost the ability to run Excel macros, which we use frequently. We employ multiple Windows operating systems (XP or Wondows 7 Pro) and either Excel 2007 or 2010. The two computers that can still run macros are newer Win7 Pro and Excel 2010.

The frustrating part is that I have enabled marcos and VBA Project Object model access on my Excel and this does not fix it. I have also added the file location as a trusted document as well. There is not notification pop-ups of any kind to give me a clue.

We work in a small company so there would not have been any administrative security changes without my involvement.

My guess is that this is a Microsoft OS or Excel update that can caused a change. Does anyone know of such and issue or know where I can look it up? Internet searches have not provided any answers.

 

[Michael M]

The files did get saved as xlsm didn't they ??
Also, try

Make sure that events are enabled. In the code window press CTRL + G then in the Immediate window type

Application.EnableEvents=True

then press Enter.

 

[Singyt]

Thanks Michael M.

I am saving as .xlsm.

I have tried enabling the event and that does not seem to have an affect.

What is curious is that I can run the code through the VB window. It's my macro control button that is disabled.

Please let me know if you have any additional suggestions.

 

[Michael M]

Is it an ActiveX control Button ?
There has been a recent update to Office that seems to have broken these controls

See Here:

Office Update breaks ActiveX controls | Excel Matters

 

[Singyt]

Thank you. I will research this. Sounds like that should be it.