PDA

View Full Version : Annoying privacy warning



frubeng
05-29-2009, 10:37 AM
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!

Oorang
05-29-2009, 11:38 AM
What controls are you using that are triggering the alert?

Kenneth Hobs
05-29-2009, 11:56 AM
See http://support.microsoft.com/kb/240797/EN-US/

frubeng
05-29-2009, 12:39 PM
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?

frubeng
05-29-2009, 01:03 PM
See http://support.microsoft.com/kb/240797/EN-US/

I am confused, this is for Internet Explorer isnt it?

Oorang
05-29-2009, 02:37 PM
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?

Kenneth Hobs
05-29-2009, 08:03 PM
See if this helps. http://office.microsoft.com/en-us/help/HA100310671033.aspx

Kenneth Hobs
05-29-2009, 09:03 PM
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.aspx?SCID=kb;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.

frubeng
06-01-2009, 07:03 AM
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?

frubeng
06-01-2009, 07:07 AM
See if this helps. http://office.microsoft.com/en-us/help/HA100310671033.aspx

I have definitely enabled all macros/ActiveX

frubeng
06-01-2009, 07:30 AM
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.aspx?SCID=kb;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... :(

Kenneth Hobs
06-01-2009, 08:15 AM
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.