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?

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!

JMSatMetro wrote:

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