On Jun 25, 5:05 pm, Pflugs wrote:
Ardy,

I have not signed my add-ins and macro-containing spreadsheets. For me,
it's not worth the extra yearly cost (yet). However, if you are interested
in pursuing a certificate, this link provided by Microsoft lists some
prominent companies.

http://msdn2.microsoft.com/en-us/library/ms995347.aspx

If you are only doing one spreadsheet, I really don't think it's worth a
yearly fee, though.

Pflugs

"Ardy" wrote:
On Jun 25, 1:45 pm, Pflugs wrote:
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

OK I was looking on line to see how I can buy one, it seem to be the
only way I can trutfully say I am not a bad guy. Could somebody tell
me what type I should get, All I have a a single Excel file that I
will be distributing to who ever. I was looking at veri Sign but
there are diffrent types.....
Can somebody point me to the right direction. I know this is a touchy
subject.....
Ardy

Thanks for the reply, As you can see I am new to all of this
programming and logistics of what to do and distribute what I have. My
next step I guess is to turn what I have to an plugin. but I have to
learn how to do that. I agree abt the cost tied in to single
spreadsheet. but thenagain it started as an simple spreadsheet and
has gotten to be quite elaberate, I am to the point that need to
decide on my next action. I do thank you for your guidance.

Ardy