Hi All,

We have an Add-In that uses ActiveX controls as part of its implementation.

When we try to run this on Excel 2002 (XP), we get the following Yes/No warning:
"This application is about to initialize ActiveX controls that might be unsafe. If you trust the source of this file, select OK and the controls will be initialized using your current workspace settings."

I have two questions:
- Is there a way for the user to set an option, so that this pop-up will not show, and the ActiveX control will be properly initialized?

- How do I "sign" the ActiveX to prevent these errors? I know that there are registry keys that can be set for using ActiveX controls in Internet Explorer, but those keys don't seem to prevent this problem.

Thanks,
Paul

Paul,

I was wondering if you were ever able to solve this problem. I'm having the same problem right now.

Thanks,
Bich

Q2: It's not an 'ERROR'. Whats the idea with a warning that anyone could override by code?

Q1: have you tried changing the settings under Function/Macros/Security ?

I don't consider the message an error. I just want to know what setting is bringing up the message. I've looked at the settings under Security, but that's not it. I've also looked at the Norton Anti-Virus office plug-in, but that's not it. Office also has a group policy setting that deals with "Unsafe ActiveX controls". I tried changing that, but it doesn't work. What a pain!

Maybe not, but that's what pagates mentioned and my answer was aimed at that Q.

Ms is describing how to change your own registry settings but also warns you to do so:

http://support.microsoft.com/default...b;en-us;827742

I don't know if that's what you're asking for.

Oops. Sorry. Thanks for the reply. I tried that registry setting also, and that still didn't work.

Well, it seem as if we're stuck with it. There's a lot about securitysettings here but I expect you've already visited the place and I don't know whether there's anything of interest for you:

http://www.microsoft.com/technet/pro...ain/xpsec.mspx

Sorry I can't help.

Hi Paul, I wanted to ask you if you could find a solution to this problem.

Thank you...

I am running in to the same issue, I want an excel created and send it out as an email, the popup warning is not allowing me to automate this procedure, please let me know if you have a solutions.

Thanks
SK

Hi,

I hope this post isn't coming too late.

I had thesame issues and this was the solution.

Forms3 and ActiveX initialization (Office 2003 and Office XP)
By using the common security registry key, you can instruct the Office 2003 and Office XP programs to set Forms3 ActiveX initialization security for all Office 2003 and Office XP programs that support Forms3. If the setting of the key is 2 or 3, the user is prompted to determine how Forms3 forms will load. The prompt only appears one time per session in a program. The location of the registry key is the following:
HKEY_CURRENT_USER\Software\Microsoft\VBA\Security
In either the registry or policy node, the value name LoadControlsInForms can be set to the following values and respective actions.Value name: LoadControlsInForms
Value type: REG_DWORD
Value Data: [ 1 | 2 | 3 | 4 ]

Description of the value data
The value data can be explained as follows:• Use 1 for a UFI or SFI signed control that supports safe and unsafe mode, load the control in unsafe mode. For an SFI signed control that only supports a safe mode configuration, load the control in safe mode.
• Use 2 (default setting) for a UFI signed control, if the user responds with a Yes to the prompt, load the control in unsafe mode. If the user responds with a No, load using the default properties. For an SFI control that supports both a safe and unsafe mode, if the user responds to the prompt with a Yes, load the control in unsafe mode. If the user responds with a No, load the control using safe mode. If the SFI control can only support safe mode, load the control in safe mode.
• Use 3 for a UFI signed control, if the user responds with a Yes to the prompt, load the control in unsafe mode. If the user responds with a No, load the control with its default properties. For an SFI control, load in safe mode.
• Use 4 for a UFI signed control, load with the default properties of the control. For an SFI control, load in safe mode (considered to be the safest mode).


Refer to the link below for a comprehensive description of the solution.
http://support.microsoft.com/default...Product=xl2003

If the security key does not exist create it.

Hope this works.