Wednesday, April 07, 2010

Excel Quick Tips: Disable Privacy Warning

If each time when you save your macro enable workbook, you receive an annoying popup "Privacy warning:This document contains macros, ActiveX controls, XLM expansion pack information, or web components. These may include personal information that cannot be removed by the Document Inspector", follow these steps

1.  Go to Excel Options, navigate to Trust Center and click on “Trust Center Settings”

2. First, enable all macros in the Macro Settings (Note: Assuming all your macros are safe and tested)

Enable-Macro

3. Then go to Privacy Options and uncheck “Remove personal information…”

DocInspector

4. Save and close the file. Next time when you open it, no more annoying privacy warnings.

Post a Comment