Page 1 of 2 12 LastLast
Results 1 to 10 of 12
Like Tree1Likes

how to remove Privacy Warning

This is a discussion on how to remove Privacy Warning within the Excel Questions forums, part of the Question Forums category; Hi Every body, every time i save excel sheet (With VBA code). warning message appeared which is: " Privacy Warning:this ...

  1. #1
    New Member
    Join Date
    Dec 2010
    Posts
    9

    Default how to remove Privacy Warning

    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

  2. #2
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,520

    Default Re: how to remove Privacy Warning

    See if this helps Privacy warning
    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    Board Regular pedie's Avatar
    Join Date
    Apr 2010
    Location
    NZ@In
    Posts
    3,779

    Default Re: how to remove Privacy Warning

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

    Code:
    Sub try()
    Application.DisplayAlerts = False
       ActiveWorkbook.Save
    Application.DisplayAlerts = True
    End Sub
    Hi Peter!
    Regards,
    Pedie
    MS OFFICE 2013: Window7: 64BIT

  4. #4
    New Member
    Join Date
    Dec 2010
    Posts
    9

    Default Re: how to remove Privacy Warning

    HI,
    it works thx alot,

    Nahla

  5. #5
    New Member
    Join Date
    May 2011
    Posts
    1

    Cool Re: how to remove Privacy Warning

    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"
    rimdesuja likes this.

  6. #6
    New Member
    Join Date
    Sep 2011
    Posts
    1

    Thumbs up Re: how to remove Privacy Warning

    Worked like a breeze!
    Thanks a lot..

  7. #7
    New Member
    Join Date
    Mar 2012
    Posts
    1

    Default Re: how to remove Privacy Warning

    Thanks Swing,

    This solution worked a charm.

    Gustav

  8. #8
    New Member
    Join Date
    Apr 2012
    Posts
    1

    Default Re: how to remove Privacy Warning

    Thanks. It worked.

  9. #9
    New Member
    Join Date
    Aug 2012
    Posts
    8

    Default Re: how to remove Privacy Warning

    TKX! it works fine for me!

  10. #10
    Board Regular
    Join Date
    Aug 2002
    Posts
    83

    Default Re: how to remove Privacy Warning

    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?

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com