PC Review


Reply
Thread Tools Rate Thread

Disable Security Warnings Screen

 
 
=?Utf-8?B?QWNjZXNzSGVscA==?=
Guest
Posts: n/a
 
      7th Nov 2007
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.


 
Reply With Quote
 
 
 
 
Ian
Guest
Posts: n/a
 
      7th Nov 2007
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" <(E-Mail Removed)> wrote in message
news:CE69DE82-E5D5-4C6F-8A3C-(E-Mail Removed)...
> 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.
>
>



 
Reply With Quote
 
=?Utf-8?B?QWNjZXNzSGVscA==?=
Guest
Posts: n/a
 
      7th Nov 2007
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" <(E-Mail Removed)> wrote in message
> news:CE69DE82-E5D5-4C6F-8A3C-(E-Mail Removed)...
> > 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.
> >
> >

>
>
>

 
Reply With Quote
 
=?Utf-8?B?VGV4YXMgQWdnaWU=?=
Guest
Posts: n/a
 
      7th Nov 2007
Self Signed Digital Signatures

http://msdn2.microsoft.com/en-us/library/aa141471(office.10).aspx

This is self signing, for a Certified Digial Signature will allow any
computer to accept it, but you usually have to pay for it unless you know how
to write one.

--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"AccessHelp" wrote:

> 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" <(E-Mail Removed)> wrote in message
> > news:CE69DE82-E5D5-4C6F-8A3C-(E-Mail Removed)...
> > > 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.
> > >
> > >

> >
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable the Security warnings xxnonexspamxnonexx@tampascanner.info Windows XP General 1 19th Aug 2006 02:39 PM
How to disable SP2 security warnings ? Lucius Snow Windows XP Customization 5 22nd Aug 2004 11:39 AM
How to disable SP2 security warnings ? Lucius Snow Windows XP Internet Explorer 1 22nd Aug 2004 01:40 AM
How to disable SP2 security warnings ? Lucius Snow Windows XP Setup 0 21st Aug 2004 11:49 PM
How to disable SP2 security warnings ? Lucius Snow Windows XP Security 0 21st Aug 2004 11:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:18 PM.