Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2005

Tip: Looking for answers? Try searching our database.

Security Issues

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
G. Hagg - 24 Aug 2005 21:36 GMT
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 - 24 Aug 2005 22:13 GMT
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.

> Dated 8-5-05, Graham Mayor (MVP-Word) answered a security issue as
> follows:
[quoted text clipped - 20 lines]
>
> Thank you
G. Hagg - 24 Aug 2005 23:26 GMT
Jezebel

Thank you for your response, your information was very helpful
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.