I created a vba macro that works great. It lives in a workbook that is
shared among users. In trouble shooting why it didn't always work, I found
out that some users have their macro seurity set to high. I figure there are
2 options.

1) write a macro that tests to see what the macro security is, and if it is
set to high, pop up a message with instructions to the user to lower it
2) the "very high" description reads. "Only macros installed in trusted
locations will e allowed to run." Seems to me that the most complete
solution would be to figure out what this means, make sure my macro "lives"
there (whatever that means) and then it should work for all.

What does it mean by trusted locations? Is this the Internet Options,
Trusted Sites? I thought that was for web sites only.

thx

thanks