Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: how to remove Privacy Warning

  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
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651

    Default Re: how to remove 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
    INDIA
    Posts
    3,875

    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 2016/EXCEL 2016: Window7: 64BIT
    Visit YouTube.com/VBAa2z


  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"

  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

    Default Re: how to remove Privacy Warning

    TKX! it works fine for me!

  10. #10

    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?

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