Knowledge Base

WD: VBA Code Not Saved After You Use the Undo Command

Article ID: 185143

Article Last Modified on 1/22/2007


APPLIES TO


This article was previously published under Q185143

SYMPTOMS

Visual Basic for Applications code is lost, when all of the following conditions are true:
  • You open the document and make a change. -and-

  • You go into the Visual Basic Editor and insert code in a module stored in that document. -and-

  • You undo the changes you made in the document.

CAUSE

When you use the Undo command, the document is flagged as unmodified. Because the document is flagged as unmodified, the document is not saved when you use the Save command.

WORKAROUND

Save your document while the Visual Basic Editor is open. This will ensure that your Visual Basic for Applications code is saved.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Keywords: kbbug kbfix KB185143