Disable Security Warnings Screen

A

AccessHelp

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.
 
I

Ian

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
 
A

AccessHelp

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top