XL2000: Prompted to Save Changes After Setting the Saved Property to True

When you close your workbook, Microsoft Excel prompts you to save changes even though you had previously set the Saved property of the workbook to True in a Microsoft Visual Basic for Applications macro. For example, your macro contains a line of code similar to the following:

This problem occurs when any of the following conditions are true:

• You have used the Control Toolbox toolbar to add an ActiveX control to a worksheet since you last saved your workbook.
  
  -or-
  
  
• You have changed the value of an ActiveX control since you last saved your workbook. For example, you have cleared a CheckBox control or you have changed the selection in a ListBox control.

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base: To temporarily work around this problem if you are using one of the built-in controls from the Control Toolbox toolbar, use the equivalent tool from the Forms toolbar.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

For more information about using the Control Toolbox toolbar and the Forms toolbar, click Microsoft Excel Help on the Help menu, type activex in the Office Assistant or the Answer Wizard, click Search, and then click Add buttons, check boxes, or other controls to a worksheet to view the topic.