An XLM macro sheet (also known as an MS Excel 4 macro sheet) is essentially a worksheet, but it has some different defaults. More specifically, an XLM macro sheet displays formulas rather than the results of formulas. In addition, the default column width is larger than in a normal worksheet.
What's New in Excel 2007?
Here's a quick-and-dirty overview of the new features in Excel 2007: ■ A new tab-and-ribbon user interface
■ New XML file formats
■ Worksheet tables
■ Significantly larger worksheet grid (1,048,576 rows * 16,384 columns)
■ Ability to use more memory
■ Unlimited conditional formats per cell
■ Maximum formula length increased to 8,000 characters
■ Supports 64 levels of nesting in a formula
■ Formula AutoComplete
■ Better-looking charts
■ Workbook themes
■ Page Layout view
■ New conditional formatting options
■ Less confusing Excel Options dialog box
■ New collaboration features (requires SharePoint)
■ SmartArt and improved WordArt
■ Compatibility checker
■ Easier pivot tables
■ Twelve new worksheet functions, plus integration of the Analysis ToolPak functions
■ Resizable formula bar
■ Many new templates
■ More control over the status bar
As the name suggests, an XLM macro sheet is designed to hold XLM macros. As you may know, the XLM macro system is a holdover from previous versions of Excel (version 4.0 and earlier). Excel 2007 continues to support XLM macros for compatibility reasons - although it no longer provides the option of recording an XLM macro. This book does not cover the XLM macro system; instead, it focuses on the more powerful VBA macro system.
Was this article helpful?