Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Security Setting | Excel Discussion (Misc queries) | |||
High Security setting | Excel Programming | |||
Macro not able to run due to a security setting | Excel Discussion (Misc queries) | |||
Security setting on Low, but Macro will not run? | Excel Programming | |||
Security setting of low ignored for macros | Excel Programming |