- [Instructor] I've opened another document…where I want to run my macro.…Before I do that, I want to check my macro security settings…to make sure that I get to run my macros.…To do this, let's go to File, and let's go to Options,…and we are on our way to the Trust Center.…And click Trust Center Settings and notice where it says…Macro Settings, Disable all macros with notification,…that's exactly how we would like…to have this setup right now.…
The first choice, Disable all macros without notification,…you'll never be allowed to run a macro.…And the second allows us to say no, we actually know…there are macros in this document and want to use them.…The third choice is the same as the first except if…a macro has been digitally signed, it becomes an exception.…It's a really bad idea to simply enable all macros…because 80 to 90% of the security risk that is…being aimed at office documents are created using macros.…
So please don't enable all macros.…But we want to be notified before macros…are going to be disabled.…
- List the steps required to run the macros on a document you created when you open the document and see a SECURITY WARNING banner message.
- Explain how to run a macro.
- Identify where to save a building block if there is no logical gallery for it.
- Recall the best way to create an auto macro.
- Recognize why you would create a macro in the Visual Basic Editor rather than using the Macro Recorder.
- Identify what you can add any existing macro to.