Consulting

Results 1 to 12 of 12

Thread: Annoying privacy warning

  1. #1
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location

    Annoying privacy warning

    Hello again,

    As I run my program, I get the following message:

    "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"

    If i click ok, the program seems to resume fine. The problem is that it seems to pause the program, and reuire me to click OK.

    Further, this message appears 4 times. This might be because my main program writes to 4 other spreadsheets.

    How does one prevent this message from appearing?

    (NOTE: The warning even appears when the program is not running (as in paused))

    Thanks!

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    What controls are you using that are triggering the alert?
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  3. #3

  4. #4
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location
    Quote Originally Posted by Oorang
    What controls are you using that are triggering the alert?
    1.
    I've done the the following things:
    Go to 'Developer Ribbon'.
    Click Macro Security.
    Click 'Privacy Options'.
    Uncheck all notifications.
    2.
    Excel Option > Trust Center > Trust Center Setting > Macro Settings > click Enable All Macros ....
    3.
    Excel Option > Trust Center > Trust Center Setting > Active X Settings > click Enable All controls without restriction

    What do you mean by controls?

  5. #5
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location
    Quote Originally Posted by Kenneth Hobs
    I am confused, this is for Internet Explorer isnt it?

  6. #6
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    A control would be anything you added to a userform. Ex Textbox, label etc. Is this a program you wrote or one you are using?
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  7. #7
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location

  8. #8
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Be sure that you understand how to restore your registry if you try a registry hack.

    I used the Forms3 part for 2003 on VistaHP. I tested it with the pdf control and it was fine. http://support.microsoft.com/default...b;en-us;827742

    Here is my reg file for this:
    Windows Registry Editor Version 5.00
    [HKEY_CURRENT_USER\Software\Microsoft\VBA\Security]
    "LoadControlsInForms"=dword:00000001
    That is not much security if a registry hack can turn off those messages.

  9. #9
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location
    Quote Originally Posted by Oorang
    A control would be anything you added to a userform. Ex Textbox, label etc. Is this a program you wrote or one you are using?
    This is a program I wrote. It reads in data from its spreadsheet, checks for things and writes comments to 4 other spreadsheets.
    These 4 spreadsheets and the main 1 have all ActiveX and macros enabled.

    I also tried putting them in trusted location, but it says my current security settings does not allow me to do that, whatever that means?

  10. #10
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location
    Quote Originally Posted by Kenneth Hobs
    I have definitely enabled all macros/ActiveX

  11. #11
    VBAX Regular
    Joined
    Apr 2009
    Posts
    59
    Location
    Quote Originally Posted by Kenneth Hobs
    Be sure that you understand how to restore your registry if you try a registry hack.

    I used the Forms3 part for 2003 on VistaHP. I tested it with the pdf control and it was fine. http://support.microsoft.com/default...b;en-us;827742

    Here is my reg file for this:
    Windows Registry Editor Version 5.00
    [HKEY_CURRENT_USER\Software\Microsoft\VBA\Security]
    "LoadControlsInForms"=dword:00000001
    That is not much security if a registry hack can turn off those messages.
    I just followed the instructions on that website and changed my security to 1 (from 2). But the message is still popping up...

  12. #12
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Changing sercurity is just going to stop the dialog whether you want to activate macros or not.

    Do the registry hack and report back. You can quickly add the key if you make the .reg file as I posted and click it in Explorer.

    I don't have 2007. If you post a 2003 xls that has the problem, I could more readily test it.

Posting Permissions

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