Article ID: 238488
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q238488
SYMPTOMS
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:
ThisWorkbook.Saved = True
CAUSE
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.
RESOLUTION
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:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
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.
STATUS
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.
MORE INFORMATION
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.
Additional query words: XL2000
Keywords: kbbug kbdtacode kbpending KB238488
