OFFXP: "Remove Personal Information from This File on Save" May Not Work with Macros (286394)


The information in this article applies to:

  • Microsoft Excel 2002
  • Microsoft PowerPoint 2002
  • Microsoft Word 2002
This article was previously published under Q286394

SYMPTOMS

If your document contains macros and you have selected the Remove personal information from this file on save check box (on the Tools menu, click Options, and then click the Security tab), you may receive the following warning message after you save the document:
Privacy Warning: This document contains macros, ActiveX controls, or Web components. These may include personal information that cannot be removed by the "Remove personal information from this file on save" option on the Security tab of the Tools Options dialog box.

CAUSE

Macros, ActiveX controls, and Web components may contain commented information within the code. You cannot remove personal information in these comments by selecting the Remove personal information from this file on save check box.

WORKAROUND

To work around this behavior, you must manually remove any personal information from comments contained in the code.

Steps to Reproduce the Behavior

To record a Microsoft Visual Basic for Applications macro and observe this behavior, follow these steps:
  1. Create a new workbook in Microsoft Excel 2002.
  2. On the Tools menu, point to Macro, and then click Record New Macro. In the Store macro in list, click This Workbook and then click OK.
  3. Select cell C3. Then, click the Stop Recording button on the Stop Recording toolbar.
  4. On the Tools menu, point to Macro, and then click Visual Basic Editor. Then, in the Project window, double-click Module1 in the Modules folder.

    Note that the recorded macro contains the name of the user who recorded it.
  5. Press ALT+F11 to switch to Excel.
  6. On the Tools menu, click Options.
  7. On the Security tab, click to select the Remove personal information from this file on save check box.
  8. On the File menu, click Save. Name the file. After you click OK, you receive the following message:
    Privacy Warning: This document contains macros, ActiveX controls, or Web components. These may include personal information that cannot be removed by the "Remove personal information from this file on save" option on the Security tab of the Tools Options dialog box.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

278579 OFFXP: "Remove Personal Information" Option Does Not Apply to Inserted Objects

Modification Type:MajorLast Reviewed:11/13/2003
Keywords:kberrmsg kbprb KB286394
©2003 Microsoft Corporation. All rights reserved.