Activating Active X Question

[weaselmcguff]

I have written a program in Excel and VBA and been testing it out to make sure that everything is working correctly. One of the problems I have encountered is that when I use the program on different computers I get the pop up that asks me.

"This application is about to initalize Active X 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 environment."

Is there any way to automatically do an error trap and/or something that eliminates this pop up by selecting OK and proceeding without the user interaction?

Thanks for the Help

 

[Gary McMaster]

I don't think is any way around this problem, nor should there be. If you can turn it off programatically so can the jerk who gets his jollies infecting other people's computers with viruses.

I believe that you can set "Macro Security" to "low" on pre 2007 versions of Excel but that is not a very wise thing to do.

Gary

 

[Sahak]

Hi

Try this

Tools > Macros > Security, activate tab Trusted Sources,
check
Trasted all installed add-ins and templates
&
Trust access to Visual Basic Project