Closed Thread
Results 1 to 8 of 8

Privacy warning disable

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    India,Chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Privacy warning disable

    Hi,

    I am using Office 2007. When ever i save a document which contains macros in it i get the privacy warning message "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." Please let me know how to disable the message box option.

  2. #2
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: Privacy warning disable

    Excel Option > Trust Center > Trust Center Setting > Macro Settings > click Enable All Macros ....

    Excel Option > Trust Center > Trust Center Setting > Active X Settings > click Enable All controls without restriction ....

  3. #3
    Registered User
    Join Date
    04-01-2009
    Location
    India,Chennai
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Privacy warning disable

    Hi... the exact settings were already in effect in my workbook. Still the warning message is displayed...

  4. #4
    Registered User
    Join Date
    05-11-2009
    Location
    India
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    1

    Re: Privacy warning disable

    Go to 'Developer Ribbon'.
    Click Macro Security.
    Click 'Privacy Options'.
    Uncheck all notifications.

    You are done!

  5. #5
    Registered User
    Join Date
    07-09-2009
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Privacy warning disable

    In case you aren't sure what is meant by "notifications" -- this message goes away when you un-check the check box labelled "Remove personal information from file properties on save". I don't see any other "notifications" option.

    The annoying things about un-checking this check box are (a) it means that personal information is not cleared out whenever you save the spreadsheet; and (b) this is a spreadsheet-specific setting, not a general setting.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Privacy warning disable

    Quote Originally Posted by mubashir aziz View Post
    Excel Option > Trust Center > Trust Center Setting > Macro Settings > click Enable All Macros ....

    Excel Option > Trust Center > Trust Center Setting > Active X Settings > click Enable All controls without restriction ....
    Doing this is an invitation to disaster. One malicious macro and you will have the opportunity to rebuild your computer from scratch, and then spend the next month recovering from identity theft.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    01-25-2010
    Location
    Portland, OR, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Privacy warning disable

    Quote Originally Posted by shg View Post
    Doing this is an invitation to disaster. One malicious macro and you will have the opportunity to rebuild your computer from scratch, and then spend the next month recovering from identity theft.


    so you have a better solution? That pop up window is really, really annoying, and I get it all the time (not just when opening and closing a file either).

  8. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Privacy warning disable

    benjaminvw, welcome to the board, please note though:

    Your post does not comply with Rule 2 of our Forum RULES.
    Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

    Thanks

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1