View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ardy Ardy is offline
external usenet poster
 
Posts: 136
Default Security - Setting

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