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