Warning Message in VBA...

[JaedenRuiner]

Microsoft Forms
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.

How can I turn this off? It is really annoying, and since the ActiveX components I am using have already proved to work just fine, i don't want this message popping up EVERY time i run this macro. Thanks,

Jaeden "Sifo Dyas" al'Raec Ruiner

 

[lark_tilly]

Have you put SetWarnings = No into the macro before the action which results in the msg? If not, you could try that, as long as you're sure you are okay with ignoring the msg. Be sure to put SetWarnings = Yes afterwards.

 

[JaedenRuiner]

Hrm.

Well i looked for SetWarnings, cause I know that from Access, but didn't see it. This is a VBA UserForm for Excel and Word, and it basically includes a non-windowed ActiveX control that I use to zip files in the background. When I created it manually (with a dim x as New object) it never complained, but that meant setting a lot of the Attributes/properties manually. When i drag-drop it on the form, i can just set the global properties and be done with it. So, it isn't like there is a "statement" that causes the warning, it's the existence of the control on the userform.

Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner

 

[Bodisathva]

try:
Tools -> Options -> Security and set it to low

 

[JaedenRuiner]

try:
Tools -> Options -> Security and set it to low

Already Thought of that...didn't affect it. It still complained about the ActiveX component.

 

[KernelK]

In excel using Application.DisplayAlerts = False is the same as SetWarnings = No. Be sure to turn them right back on though with Application.DisplayAlerts = True.