XLM macro sheets

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?

0 0


Post a comment