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

The purpose of that excel message is to prevent macros from running unless
the user allows it. Therefore, you can't write a macro to test for the
security because security won't run the macro.

I usually have the workbook set to a certain sheet before closing. On that
sheet i'll have instructions that say some functions of the workbook won't be
available unless macros are enabled. Give instructions on how to enable,
then make sure to tell the user to close the file and reopen it in order to
set the changes.
--
JNW


"xrbbaker" wrote:

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

Thanks JNW. Rats. The macro performs an audit function. It captures name
and userid any time a user updates a row, and writes that to the two end
columns. From a user's point of view, they couldn't care less as the lack of
audit function doesn't impact their ability to do work.

Thanks much

"JNW" wrote:

The purpose of that excel message is to prevent macros from running unless
the user allows it. Therefore, you can't write a macro to test for the
security because security won't run the macro.

I usually have the workbook set to a certain sheet before closing. On that
sheet i'll have instructions that say some functions of the workbook won't be
available unless macros are enabled. Give instructions on how to enable,
then make sure to tell the user to close the file and reopen it in order to
set the changes.
--
JNW


"xrbbaker" wrote:

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