disable 'enable macros' pop-up message on all computers


A

Adam

Is there any way to automatically disable the 'enable macros' pop-up message
on all computers that use a workbook. I know I personally can change my
security settings to low, but I'm not the only person using the workbook.
Maybe there's a way to attach a digital certificate to the document while
sending it out?

Thanks,

Adam
 
Ad

Advertisements

D

Dave Peterson

It wouldn't be much security if your macro could make the choice for me.

An alternative ...

Look in Excel's help for: "Create your own digital certificate"

If your users trust you (once), then that should be enough.
 
G

Gord Dibben

SelfCert DC's only good on computer on which they are created..

Keys cannot be exported to other computers.

You can purchase from Thawte or Verisign or similar.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

Thanks for the correction, Gord.

I've never used it.

I think (another guess that could be wrong) that xl2007 allows the user to place
the file in a trusted location.
 
G

Gord Dibben

I think that 2007 guess is correct but that opinionn is based upon hearsay and
not experience.


Gord
 
Ad

Advertisements

Ad

Advertisements


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