Hello Experts,

I need your help!

I am using the excel 2010 on Win 7. I found I cannot change the macro security settings, all of them are greyed out.

Interesting thing is I can record the macro and run it, but I cannot run any macro when I import it from outside. Currently the system setting for macro is "Disable all macros with notification"

Please help me out.

Edward

Hi Edward,

I'd like to know whether you are now alone in your home using the Excel 2010 or you are working in your company in an Enterprise environment?

Generally, these options could be disabled by group policy settings controlled by your domain admins, if so, you could hardly to make a change without permission from them.

If you are now home alone, try to check your group policy settings.

Typing GPEDIT.MSC in the Run box. Navigate to

User Configuration/Administrative Templates/Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/VBA Macro Notification Settings Enabled

Disable this setting if it is enabled.

You may need to use the gpupdate /force command to have this change to take effect.

To enable all macros :

File tab => Excel Options => Trust Center => Trust Center Setting => Macro Settings to enable all macros.

For checking your macros :

Alt+F11

Hi Edward,

I'd like to know whether you are now alone in your home using the Excel 2010 or you are working in your company in an Enterprise environment?

Generally, these options could be disabled by group policy settings controlled by your domain admins, if so, you could hardly to make a change without permission from them.

If you are now home alone, try to check your group policy settings.

Typing GPEDIT.MSC in the Run box. Navigate to

User Configuration/Administrative Templates/Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/VBA Macro Notification Settings Enabled

Disable this setting if it is enabled.

You may need to use the gpupdate /force command to have this change to take e

Hi Max,

I just stumbled upon the same issue as Ed last year.  Though I'm on the Enterprise network, I did check on the settings that you suggested above but could not notice such enforcement/s.  Moreover, the macro settings was accessible to me few days ago, before I encountered with this issue.  Can you please advise next course of action to rectify the situation?

Thanking you,

Naresh

try with another user login if it works then rename user profile i tried for one user and it works.

Dear Edward

       I have the same issue with you, can not enable office macro on Win 7, I created some macro but can't working, if you have do some setup can run macro pls share to me. thank you.

 Sincerely,

  Cody

Hi Max,

I tried but I cannot found Microsoft Excel 2010 in Administrative Templates.

Could you please another way to fix the problem ? or have you solution for this?

Thank you.

Regards,

Beatrix

If you not have installed the Office ADM policy pack, you can't find the mentioned setting in the GP editor. But policies are handled through registry.

Try delete HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\14.0\excel\security\VBAwarnings

If its an active policy, it will reappear at next policy refresh

Hi Max,

I had the same issue as Edward that the Macro option is grey out. But my Excel version is 2013 and I can not find the group policy at location of 'User Configuration/Administrative Templates/Microsoft Excel 2010/Excel Options/Security/Trust Center/Trusted Locations/VBA Macro Notification Settings Enabled'.

Is there any advice for my problem?