Macro security


show more Macro security provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Macro security

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 con...

Macro security
Video duration: 2m 12s 5h 13m Beginner

Viewers:

Macro security provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...