Hi Ian,

Thanks for sharing the information. Unfortunately, it will be hard to
perform those options because the macro will be used by the users.

Thanks again.

"Ian" wrote:

No. That's the whole point of security settings. If you could
programmatically override this security feature, it wouldn't be very secure.

That siad, there are 2 options.
1. Set security in Excel to low. This way you won't get prompted for ANY
macros, even suspect ones.
2. Look into digital signatures. I've not used them myself, but they are a
way of allowing macros to run as long as they are from a recognised and
authorised source.

Ian

"AccessHelp" wrote in message
...
Hello,

Is there a way to disable the Security Warnings screen and to
automatically
select the Enable Macros button from the Security Warnings screen?

I have a worksheet with a command button. When the button is clicked, it
will call the macro. Then I will get the Excel Security Warnings screen.
I
don't want the Security Warnings screen to prompt.

Thanks.