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!

What controls are you using that are triggering the alert?

See http://support.microsoft.com/kb/240797/EN-US/

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?

Quote:

---

Originally Posted by Kenneth Hobs

See http://support.microsoft.com/kb/240797/EN-US/

---

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

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?

See if this helps. http://office.microsoft.com/en-us/he...310671033.aspx

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:

Code:

---

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.

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?

Quote:

---

Originally Posted by Kenneth Hobs

See if this helps. http://office.microsoft.com/en-us/he...310671033.aspx

---

I have definitely enabled all macros/ActiveX

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:

Code:

---

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... :(

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.