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.
- On the Security tab, click to select the Remove personal information from this file on save check box.
- 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.