Microsoft KB Archive/211414

= XL2000: UserForm Is Lost When Saving in Earlier Version Format =

Article ID: 211414

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211414





SYMPTOMS
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

may contain features that are not compatible with Microsoft Excel 5.0/95 Workbook. Do you want to save the workbook in this format?

where  is the name of your workbook.



CAUSE
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.



RESOLUTION
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:

Microsoft Excel 97/2000 & 5.0/95 Workbook



MORE INFORMATION
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:

213255 XL2000: How to Add MS Excel 5.0 Dialog Sheet to a Workbook

