Forum Discussion
dapper49
Feb 29, 2024Copper Contributor
Macros and VBA
I am taking an online course for macros. When I try to download a sample worksheet for the course, I receive the message: "Security Risk. Microsoft has blocked macros from running because the source...
Rodrigo_
Feb 29, 2024Iron Contributor
dapper49
change macro setting in trust center under File tab.
- Go to the File tab and select Options.
- Click on Trust Center, then choose Trust Center Settings.
- In the Trust Center, select Macro Settings.
- You’ll find several options:
- Disable all macros without notification: Macros and security alerts are disabled.
- Disable all macros with notification: Macros are disabled, but security alerts appear if macros are present.
- Disable all macros except digitally signed macros: Unsigned macros are disabled, but signed ones run.
- Make the selections you want and click OK.
dapper49
Feb 29, 2024Copper Contributor
Thank you. I tried all of your suggestions. When I try to run the macro in the file, I receive this message:
"Cannot run the macro "Vigorous-VBA-Lesson-1 etc.......". The macro may not be available in the workbook or all macros may be disabled."
So I am still stumped.