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

• Microsoft Excel 2000

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.

WORKAROUND

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 this to be a problem in the Microsoft products listed at the beginning of this article.

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 : kbdta kbdtacode xlloadsave xlvbainfo OffVBA KbVBA DTIR
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug