Macros are disabled and I cannot enable them

Singyt

New Member
Joined
Feb 27, 2003
Messages
26
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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,212,932
Messages
6,110,748
Members
448,295
Latest member
Uzair Tahir Khan

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