Security Levels and Macros

[Guest]

I have a spreadsheet that I want to distribute to multiple users presumably
with different versions of MS Excel. This spreadsheet contains a macro, that
will only run if user's software has a security level of medium or lower. Is
there a way to get around this limitation, perhaps by embedding a security
level certificate in the actual spreadsheet when I send it out to people, so
that it automatically adjusts their security on there systems to enable the
use of the macro?

 

[Dave Peterson]

It's an education issue for the user.

If your code could change this setting, then anyone (especially writers of
malicious code) could do it, too.

And then it wouldn't be too secure!