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

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.

Adam wrote:

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

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

On Thu, 17 Apr 2008 13:14:18 -0500, Dave Peterson
wrote:

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

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

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 wrote:

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

On Thu, 17 Apr 2008 13:14:18 -0500, Dave Peterson
wrote:

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

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

--

Dave Peterson

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


Gord

On Thu, 17 Apr 2008 19:31:47 -0500, Dave Peterson
wrote:

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 wrote:

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

On Thu, 17 Apr 2008 13:14:18 -0500, Dave Peterson
wrote:

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

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

Someday -- for both of us <vbg.

Gord Dibben wrote:

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

Gord

On Thu, 17 Apr 2008 19:31:47 -0500, Dave Peterson
wrote:

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 wrote:

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

On Thu, 17 Apr 2008 13:14:18 -0500, Dave Peterson
wrote:

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

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

--

Dave Peterson