Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


Keywords: KB286394, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 286394
Revision : 3
Created on : 1/29/2007
Published on : 1/29/2007
Exists online : False
Views : 346