Microsoft KB Archive/286394

= OFFXP: &quot;Remove Personal Information from This File on Save&quot; May Not Work with Macros =

Article ID: 286394

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft PowerPoint 2002 Standard Edition
 * Microsoft Word 2002 Standard Edition

-



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 &quot;Remove personal information from this file on save&quot; 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:  Create a new workbook in Microsoft Excel 2002. 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. Select cell C3. Then, click the Stop Recording button on the Stop Recording toolbar. 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. Press ALT+F11 to switch to Excel. On the Tools menu, click Options.</li> On the Security tab, click to select the Remove personal information from this file on save check box.</li> 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 &quot;Remove personal information from this file on save&quot; option on the Security tab of the Tools Options dialog box.

</li></ol>

<div class="references_section">