XL2000: UserForm Is Lost When Saving in Earlier Version Format

If you save a workbook in the file format for an earlier version of Microsoft Excel, any UserForms in the file are not saved.

Note that when you save your workbook in an earlier version's format, you receive the following message
where file name is the name of your workbook.

This problem may occur if all of the following conditions are true:

�	You add a UserForm to your Microsoft Excel workbook. -and-
�	You save the file in a file format for an earlier version of Microsoft Excel.

To save your file in a file format for an earlier version such as Microsoft Excel 5.0 or Microsoft Excel 95, do not choose the Microsoft Excel 5.0/95 file format. Instead, choose the following file format:

A UserForm is a feature in Microsoft Excel that is not supported by versions of Microsoft Excel earlier than Microsoft Excel 97. These earlier versions use a Dialog Sheet instead of a UserForm.

For additional information about using Dialog Sheets in Microsoft Excel 2000, please see the following article in the Microsoft Knowledge Base:

For more information about saving files in an earlier file format, click Microsoft Excel Help on the Help menu, type About using Microsoft Excel 2000 files with earlier versions of Excel in the Office Assistant or the Answer Wizard, and then click Search to view the topic.