Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Because you're doing a little bit of programming when you're recording a macro, there are some security settings that you need to be aware of. And we're going to review those now under the Macro Security command in the Developers tab. If you select that, it automatically opens up to your Macro Settings screen, and you have your options to disable your macros. And you might have noticed this if you've been working with other worksheets that do have macros embedded in them, when you go to open those up, you're going be asked to whether or not you want to enable or disable them.
And let's just review some of these options here. Disabling all macros without notification would be used if you don't trust macros. All macros and any documents and security alerts of macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location, and they will automatically be able to be run. But if you have any concerns at all about using macros in other spreadsheets, then this would be the selection that you would have. The default option is, Disable all macros with notification. You will be prompted whether or not you want to accept the macro in the worksheet that you're being offered that you're opening up.
And this way, you get to enable the ones on a case-by-case basis, and use those that you are very comfortable using. Next selection is disabling all macros except digitally signed macros. Now, this allows you to place a trusted publisher, and it'll always allow those particular macros to be opened without prompting. And you would put their names up here in the Trusted Publisher section. For example, Microsoft. You would always except anything that came--any macro that came--embedded in a worksheet that was signed by Microsoft.
That would be something that you can do. Finally, enable all macros, and this is not recommended because these could potentially do serious harm and damage to your code within your spreadsheet. So, powerful as macros are for saving you time, they are potentially dangerous. So always be aware when you are working with them, and very rarely go with the setting of Enable all macros.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90696 Viewers
80 Video lessons · 137975 Viewers
59 Video lessons · 56753 Viewers
52 Video lessons · 70374 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.