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

When working with macros in Excel 2010, you save and open workbooks in a new macro-enabled workbook format (.xlsm) that provides added security. When you create a macro, you must use a macro-enabled format to save your workbook or the macro won't be saved.

If you open a macro-enabled workbook, a Security Warning message states that the workbook contains macros. This protects you from possible harm — some macros might contain viruses or other hazards. You can choose to enable the content if the workbook is from a trusted source.

Save a macro-enabled workbook

Follow these steps to save a macro-enabled workbook:

  1. Click the File tab and then choose Save As.

    The Save As dialog box appears.

  2. Enter a name and select a location for your workbook.

  3. Click the Save as Type drop-down arrow.

    A list of file types appears.

  4. Select Excel Macro-Enabled Workbook.

    Excel adds the .xlsm extension to the filename.

  5. Click Save.

If you create a macro in a workbook and neglect to save the workbook as a macro-enabled workbook, you see a warning message telling you that the macro will not be retained.


Open a macro-enabled workbook

To open a macro-enabled workbook, follow these steps:

  1. Open a workbook containing a macro in the same way you open any other workbook.

    The workbook opens as usual, but a Security Warning message appears below the Ribbon.

  2. If you know where the macro originated, click the Enable Content button.

    The Security Warning message closes, and you're free to use the macros in that workbook.

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: