Phil

Did you use the SelfCert program to "write" the certificate?

If so, you shouldn't need to store in the Trusted Root folder.

Try this.......with your workbook open, ALT + F11 to go to VBE.

Select your workbook/project and ToolsDigital CertificatesChoose.

Select the DC you created and OK.

Save/Close your workbook.

Re-open. You may get a question about "Trusting from this source" click "yes"
to always trust.

If no joy, post back and I'll explain how to move the selfcert DC to the
Trusted Root folder.


Gord Dibben Excel MVP

On Sat, 02 Apr 2005 14:13:52 -0500, phil6666 wrote:


OK....now Excel doesn't want me to use the macro because the digital
signature that I wrote isn't in the trusted root certification
authorities store.

How do I do that???

thnx


On Fri, 01 Apr 2005 21:25:19 -0500, phil6666
wrote:


I followed Excel "help" and copy/pasted exactly what you wrote & it
works perfectly!!!

Now, if I only had a minimal clue what macros really can do.......


On Sat, 19 Mar 2005 04:58:47 GMT, Andy wrote:

ToolsCustomizeCommandsMacros

Drag the Custom Button (yellow smiley face) to your toolbar, right
click on it, assign macro (you have to have a worksheet open so the
assign macro dialog box comes up). Right clicking on the button while
the ToolsCustomize dialog box is open will also give you some other
options (like changing the smiley face).