I have a template which i need to distribute to unknown number of audiance. If "Programmatic access to Visual Basic Project is not trusted" is not checked manually, i get the following error : Programmatic access to Visual Basic Project is not trusted, "Runtime error 1004"

Is there anyway that I can set the option under: Tools, Macro, Security...Trust access to Visual Basic Project through my VBA code.

Ajitpal S Padda

__________________
Ajitpal S Padda

No! And a good job too; what's the point of having an option that prevents the running of unauthorised code if that option can be turned off by unauthorised code!
What you need is digitally sign your code in the first place, so that it becomes trusted. Here's a starting point for you
http://www.microsoft.com/office/ork/xp/two/admc04.htm


There are two secrets to success in this world:
1. Never tell everything you know

Thanks for your reply. Your are perfectly correct what you mean. But i want to use this option for programming VBE. And this is only in excel 2002 that you need to check this option to programme VBE (Like getting the names of modules, deleting VBA code etc...)

Ajitpal S Padda