Security Issues

[G. Hagg]

Dated 8-5-05, Graham Mayor (MVP-Word) answered a security issue as follows:

It is not possible to set the macro security from vba - otherwise you would
never be able to safely open a third party document. What is probably
happening here is that you have the macro security setting flagged to trust
installed templates and add-ins. Again you cannot set this remotely.

In the 2003 Microsoft help, "Automating the Visual Basic Editor" describes
recommended behavior is to check the Trust access to Visual Basic Project
box for the duration of a macro, and uncheck this box after the macro has
finished. Can I assume this is accomplished automatically with vba code? I
also assume the security level is set to high?

Can someone direct me to more detailed instructions, code for the
recommended solution above, or some remedy for security running vba macros.

Also, how would i go about purchasing a digital signature, and what are
typical associated costs.

Thank you

 

[Jezebel]

No, you can't check or uncheck the 'Trust access' checkbox via VBA code.
That's what Graham's message said. The MS article is telling you (ie the
user) how to permit one macro to run: check the box, run the macro, uncheck
the box.

Apart from the security concern, just consider the logic: 'Trust access'
must be checked for the macro to run in the first place, so if it's not
checked the macro can't run; therefore the macro can't check that box.

Why assume that the security is set to high?

You can get a digitial signature from Verisign and (presumably) others. Do a
Google. Last time I looked the cost was around $400 a year.