Forum Discussion
VB Macros are not running
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.
5 Replies
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.
HansVogelaar, Thank you for your response. I tried it and still VB macr.os are not running.
Does this occur in all workbooks or in one specific workbook?
