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

[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

 

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

 

[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

 

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

 

[Gord Dibben]

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


Gord

 

[Dave Peterson]

Someday -- for both of us <vbg>.

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

Gord