Macro Settings grayed out

%3CLINGO-SUB%20id%3D%22lingo-sub-161487%22%20slang%3D%22en-US%22%3EMacro%20Settings%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-161487%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20EXCEL%20spreadsheet%20that%20needs%20to%20use%20a%20macro%20written%20specifically%20for%20a%20task.%26nbsp%3B%20I'm%20using%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMicrosoft%20EXCEL%202016%20MSO%20(16.0.9001.2080)%2032-bit.%26nbsp%3B%20I%20am%20not%20able%20to%20change%20macro%20settings%20at%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFILE%20%26gt%3B%20OPTIONS%20%26gt%3B%20TRUST%20CENTER%20%26gt%3B%20TRUST%20CENTER%20SETTINGS%20%26gt%3B%20MACRO%20SETTINGS%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20have%20created%20a%20self%20signed%20certificate%20and%20added%20certificate%20to%20clients%20and%20EXCEL%20file%20too.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20now%20impossible%20to%20run%20macros%20even%20in%20.xlsm%20files%3F%26nbsp%3B%20Please%20help%20as%20this%20is%20killing%20this%20process%20we%20use%20on%20a%20daily%20basis.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-161487%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20%26amp%3B%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-161542%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20Settings%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-161542%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20macros%20might%20be%26nbsp%3B%3CSPAN%3Eblocked%20by%20group%20policy!%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EPlease%20follow%20this%20%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Flync%2Fen-US%2F7c3d637d-453d-4a84-ac44-c1500bed95f4%2Fmacro-settings-greyed-out%3Fforum%3Dexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Elink%3C%2FA%3E%20where%20you'll%20find%20a%20similar%20issue%3C%2FSPAN%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1182272%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20Settings%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1182272%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3BI%20followed%20the%20steps%20and%20Macro%20is%20still%20disabled.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2551583%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20Settings%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2551583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F563130%22%20target%3D%22_blank%22%3E%40hayman1681%3C%2FA%3E%26nbsp%3BIs%20this%20still%20happening%20to%20you.%20I%20am%20experiencing%20the%20same%20issue%20with%20a%20client%20who%20is%20using%20Office%20365.%20Non%20of%20the%20macros%20work%20on%20her%20PC%20and%20all%20settings%20are%20greyed%20out.%20My%20macros%20work%20everywhere%20else%2C%20only%20on%20hers%20is%20there%20a%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2551588%22%20slang%3D%22en-US%22%3ERe%3A%20Macro%20Settings%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2551588%22%20slang%3D%22en-US%22%3EGary%2C%20is%20this%20still%20happening%20to%20you%20and%20if%20not%2C%20what%20was%20your%20solution.%20I%20am%20having%20similar%20issues.%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an EXCEL spreadsheet that needs to use a macro written specifically for a task.  I'm using 

Microsoft EXCEL 2016 MSO (16.0.9001.2080) 32-bit.  I am not able to change macro settings at:

 

FILE > OPTIONS > TRUST CENTER > TRUST CENTER SETTINGS > MACRO SETTINGS

 

I have created a self signed certificate and added certificate to clients and EXCEL file too.

 

Is it now impossible to run macros even in .xlsm files?  Please help as this is killing this process we use on a daily basis.

4 Replies

The macros might be blocked by group policy!

Please follow this link where you'll find a similar issue!

@Haytham Amairah I followed the steps and Macro is still disabled.

@hayman1681 Is this still happening to you. I am experiencing the same issue with a client who is using Office 365. Non of the macros work on her PC and all settings are greyed out. My macros work everywhere else, only on hers is there a problem.

Gary, is this still happening to you and if not, what was your solution. I am having similar issues.