Disable the prompt "....ActiveX controls that might be unsafe ..."

[Inge]

We develop own features in VBA and deliver them via Visio template (VST).

Recently, we decided to use one of the existing MS ActiveX controls in our
VBA.

Unfortunately, this lead to an annoying prompt, each time someone opens the
template. The message says "This application is about to initialize ActiveX
controls that might be unsafe . . .etc".

How can we disable this prompt?

 

[Andy]

You need to use a different ActiveX control that has safe
initialisation code. There is no way around this without modifying the
code of the ActiveX control.

 

[Inge]

Well, we use a control which is part of the MS Office Web Components (OWC).
I don't see a way to modifiy this control.
Do you?

 

[Andy]

Unless there are later versions of the controls available, I believe
the only solution is to wrap the OWC controls you are using in a VB
dll and then call that from your VBA. I have had this issue with other
ActiveX controls that are unsafe and have split my app into a VBA part
and a VB dll.

 

[Paul Herber]

We develop own features in VBA and deliver them via Visio template (VST).

Recently, we decided to use one of the existing MS ActiveX controls in our
VBA.

Unfortunately, this lead to an annoying prompt, each time someone opens the
template. The message says "This application is about to initialize ActiveX
controls that might be unsafe . . .etc".

How can we disable this prompt?

You might need to look at getting a digital signing certificate.

Google for "signing active x"

 

[Andy]

Signing woule make sense for your own activex controls, but not third
party ones.