Opening and using my old macros and custom dialog boxes in Excel 2002

From Microsoft Exel 2002 Help
Using Excel 2002 files with earlier versions of Excel

Opening and using my old macros and custom dialog boxes in Excel 2002

You can open files that were created in earlier versions of Excel directly in Excel

2002. All data, formulas, and formatting that were created in earlier versions are supported by Excel 2002, with the exception of sound notes in cells.

Excel 2002 supports your Excel 2000, Excel 97, and Excel 95 Visual Basic for Applications macros. For information about compatibility issues between Excel 95 and Excel 2002 macros, click Office on the Web on the Help menu in Excel 2002.

In most cases, you do not need to change your Visual Basic for Applications and XLM macros to run them in Excel 2002. You cannot record new XLM macros in Microsoft Excel 2002. For more information about upgrading macros, see the Microsoft Office XP Resource Kit.

How to obtain Microsoft Office XP Resource Kit

The Microsoft Office XP Resource Kit is the definitive guide to installing, configuring, and supporting Microsoft Office in your organization. Designed for system administrators, consultants, and power users, this guide offers complete coverage whether you're running Microsoft Office on Microsoft Windows 98, Windows 2000, or the Macintosh.

You can obtain the Office Resource Kit wherever computer books are sold or order direct from Microsoft Press, or online at the Microsoft Office Resource Kit Web site.

To locate your nearest source for Microsoft Press products worldwide, visit the Microsoft Press Web site or contact your local Microsoft office. In the United States, call (800) MS-PRESS. In Canada, call (800) 667-1115.

Note The hyperlinks in this topic go to the Web. You can switch back to Help at any time.

To create new macros in Excel 2002, record them in Visual Basic for Applications, or write them by using the Microsoft Visual Basic Editor.

If you used dialog sheets in Excel 95
In most cases, you do not need to change your dialog sheets to run them in Excel 2002.

To create new custom dialog boxes in Excel 2002, use the UserForm command on the Insert menu in the Visual Basic Editor. For more information about creating custom dialog boxes with user forms, see Visual Basic Help