Apr 17 2022 05:59 AM - edited Apr 17 2022 06:44 AM
I have an issue when I try to run any macro, Macros are disabled. Does anyone know how to solve this issue? I tried repairing the office but it didn't work.
Apr 17 2022 06:44 AM
Select File > Options > Trust Center > Trust Center Settings... > Macro Settings.
Select "Disable macros with notification", then click OK.
When you open a macro-enabled workbook, you should get a prompt to allow macros; click Yes.
You can set one or more folders as Trusted Locations in File > Options > Trust Center > Trust Center Settings... >Trusted Locations. If you save a workbook in a trusted location, macros will automatically be enabled.
Apr 17 2022 07:05 AM - edited Apr 17 2022 07:07 AM
@Hans Vogelaar, Thank you for your response. I tried it and still VB macr.os are not running.
Apr 17 2022 07:10 AM
Does this occur in all workbooks or in one specific workbook?
Apr 17 2022 07:36 AM
@Hans Vogelaar all workbooks. As all macros are disabled.
Apr 17 2022 07:42 AM
What happens if you set Macro Settings to Enable VBA Macros, then quit and restart Excel?