Working with Excel 4.0 macros

Although Microsoft Excel 2013 still supports Excel 4.0 (XLM) macros, we encourage you to migrate them to the latest version of Microsoft Visual Basic for Applications (VBA). Migrating your macros lets you take advantage of the improvements to the VBA programming object model. To make this easier for you, some new objects, methods, and properties have been added to the object model for the few remaining functions that did not have equivalents in earlier versions of VBA. In addition, performance improvements for Page Setup operations in VBA have been added to provide similar performance to PAGE.SETUP() functionality in XLM macros.

If you decide you’re not ready to migrate, you can still run Excel 4.0 macros. When you open an XLM macro in Excel 2010 with macros disabled, Excel displays the following message:

"Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose to enable macros. For more information about enabling macros, click Help."

To change macro settings to allow you to run XLM macros, do the following: