power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

Macro-Enabled Workbook File Format


A new security feature introduced in Excel 2007 was the new ".xlsm" macro-enabled workbook file format. 

Saving files in the default ".xlsx" Excel 2007 file format will cause all VBA code associated with the file to be discarded.  If you attempt to do so, you will receive the following error message:

To save your file in the macro-enabled format, choose "Save As... Excel Macro-Enabled Workbook" from the Office Button menu, then give the file a name using the .xlsm file extension as prompted.




Prev | Contents | Next

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.