Feb 20 2018
08:34 AM
- last edited on
Jul 25 2018
09:51 AM
by
TechCommunityAP
Feb 20 2018
08:34 AM
- last edited on
Jul 25 2018
09:51 AM
by
TechCommunityAP
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.
Feb 20 2018 09:09 AM
The macros might be blocked by group policy!
Please follow this link where you'll find a similar issue!
Feb 19 2020 07:00 AM
@Haytham Amairah I followed the steps and Macro is still disabled.
Jul 15 2021 03:17 AM
@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.
Jul 15 2021 03:21 AM