All security settings must be set by the user. If they could be modified
through code, what would stop a virus from using Excel as a backdoor into
your system? Also, "Low" is not recommended since workbooks could contain
malicious code and the user would never know. Keep the setting at "Medium"
despite the hassle.

Best bet, send out a well worded memo with screenshots. If you really don't
want to have them manually change their settings, consider making or
purchasing a digital certificate. Google "Excel Digital Certificate". I
believe Bob Phillips has a tutorial on this.

HTH,
Pflugs

"Ardy" wrote:

Hello All:
How would one on Open Workbook event(Opening an spreadsheet I assume)
Automatically set the security on Low and on Trusted Sources set the
check box to Trust Access to Visual Basic Projects. The reason being
is that I have this spreadsheet which is pretty much loaded with VB
codes(Thanks to this workgroup) and am going to distribute between
bunch of teachers, I don't know if the option set under their Excel
is set to low security or the trust for VB projects is set. It really
simplifies the matter if the spread sheet can handle and set the
parameter. Any Suggestion

Ardy