Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

Security is an important issue when working with Excel 2010 macros. If you open workbooks containing macros from outside sources, these macros can be harmful to your computer. By default, Excel protects you from running macros, but if you're creating your own macros, you'll probably want to change the protective security settings.

You'll need to display the Developer tab on the Ribbon to access the macro security settings. Click the File tab and then click Options. Click the Customize Ribbon tab, and then select the Developer check box under Main Tabs on the right side of the dialog box. Click OK.

Follow these steps to view and set the macro security level in Excel 2010:

  1. Click the File tab and then click Options.

    The Excel Options dialog box appears.

  2. Click the Trust Center tab and then click the Trust Center Settings button.

    The Trust Center dialog box appears with the Macro Settings tab selected.

    Change the security level in the Trust Center dialog box.
    Change the security level in the Trust Center dialog box.
  3. Select a security level:

    • Disable all macros without notification: Allows you to run only macros that are stored in a trusted location. Click the Trusted Locations setting in the left pane to manage these trusted locations (see the figure below). Also, since the macros are automatically disabled, this option disables security alerts.

    • Disable all macros with notification: Displays a security alert when a workbook with macros opens. You can then decide whether to enable the macros associated with the workbook. This is Excel's default setting.

    • Disable all macros except digitally signed macros: You can run only those macros that are digitally signed.

    • Enable all macros: Allows macros to run without a notification. This can be helpful if you run a lot of macros, but be aware of the risk when using macros from unknown sources.

      A list of trusted file locations.
      A list of trusted file locations.
  4. Click OK two times to close both dialog boxes.

A digital signature is an electronic, encrypted, secure stamp of authentication obtained from a commercial certification authority. Excel's Visual Basic programming language contains a self-certifying digital signature tool, but because it doesn't come from a third party, Excel still considers it unauthenticated and displays a warning box before running self-certified macros.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: