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

 

[rimdesuja]

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"

Thanks Dear
Its really working only for saying you thanks I registered here and again saying you thanks......
bye...........

 

[Alphonse68]

I know that it is an old post, but I found a solution for this.
I have Excel 2010 and this is how I solved it:
File
Options
Trust Center
Trust Center Settings
and when I clicked on the Document Inspector button, it told me that it couldn't inspect the workbook because I had a Protected worksheet. Upon revising the protection of each of the worksheets, i did find one, unprotected it, and Voila!, problem solved.
IMPORTANT NOTE: If you happen to run the Doc Inspector, be very careful what you have it clean, for it does a more thorough job than when one is closing the file.

I hope this helps someone else.
Cheers.

 

[hemmi1]

I did the same in excel 2010 and it works great! Thanks

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"

 

[sirplus]

In the workbook module add the following and it will save like normal without using special buttons.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    With Application
        .DisplayAlerts = False
        .EnableEvents = False
        ThisWorkbook.Save
        Cancel = True
        .EnableEvents = True
        .DisplayAlerts = True
    End With
End Sub
[\Code]

Technically I didn't have to use the "With" and the "."s but this is better.......

 

[sirplus]

The previous code over rode the Save As box
Use this instead

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
With Application
.DisplayAlerts = False
.EnableEvents = False
If SaveAsUI Then
Application.Dialogs(xlDialogSaveAs).Show
Else
ThisWorkbook.Save
End If
Cancel = True
.EnableEvents = True
.DisplayAlerts = True
End With
End Sub

 

[sirplus]

I know that it is an old post, but I found a solution for this.
I have Excel 2010 and this is how I solved it:
File
Options
Trust Center
Trust Center Settings
and when I clicked on the Document Inspector button, it told me that it couldn't inspect the workbook because I had a Protected worksheet. Upon revising the protection of each of the worksheets, i did find one, unprotected it, and Voila!, problem solved.
IMPORTANT NOTE: If you happen to run the Doc Inspector, be very careful what you have it clean, for it does a more thorough job than when one is closing the file.

I hope this helps someone else.
Cheers.

the issue
This was not the solution for me, it didn't work/was not causing.

 

[Keebellah]

Thanks, I know this is an old post but it gave me what I was looking for