how to remove Privacy Warning

[nahla]

Hi Every body,

every time i save excel sheet (With VBA code). warning message appeared which is:

" Privacy Warning:this document contains macros,ActiveX controls,XML expansion pack information or web components. these may include personal information that cannot be removed by the document Inspector."

how can i avoid it.

thanks,
Nahla

 

[VoG]

See if this helps http://www.mrexcel.com/forum/showthread.php?t=361777

 

[pedie]

assign a button to this code & click on the button to save..

[FONT=Courier New]Sub try()[/FONT]
[FONT=Courier New]Application.DisplayAlerts = False[/FONT]
[FONT=Courier New]   ActiveWorkbook.Save[/FONT]
[FONT=Courier New]Application.DisplayAlerts = True[/FONT]
[FONT=Courier New]End Sub[/FONT]

Hi Peter!

 

[nahla]

HI,
it works thx alot,

Nahla

 

[swing]

For Excel 2007 Version :
You can follow the following steps to avoide the privacy warning.
1 Menu Button "on the top left of the excel window"
2 Excel Option
3 Trust Center
4 Trust Center setting
5 Privacy Options
6 unmark the "Remove personal information from file properties on save"

 

[ssmani]

Worked like a breeze!
Thanks a lot..

 

[Gustav]

Thanks Swing,

This solution worked a charm.

Gustav

 

[IDurai]

Thanks. It worked.

 

[Jim_Doug]

TKX! it works fine for me!

 

[AChimpNamedCornelius]

Why does it do this? I have Excel 2010 on my computer, and did right click (on desktop) create new Excel document. It creates a .xlsx, which is apparently an Excel 2003 document (???) but in any case, I add some data to cells, nothing fancy, then every time I save it it gives me this popup.

I have not done any of the 4 things listed in the warning popup:

macros,ActiveX controls,XML expansion pack information or web components

so why is it doing this anyway?