Cannot add digital signature to macros

[Guest]

I have numerous spreadsheet that I've been using for the past ten years. Way
back when I created macros to sort the data in various ways and then assigned
the macros to control buttons. They always ran just fine until we upgraded to
Excel 2003. Now the problem.

Doing a query over in the General Questions forum for "digital signature"
return about a dozen responses. I tried creating a personal certificate using
Office Tools, moving the certificates from Certificates - Current User >
Personal to Trusted Root Certification Authority > Certificates. I ran the
Detect & Repair utility from the Help menu. Nothing will let me open the
macros at our office's required security level of High. Medium requires I
authorize the macros every time.
When I try to digitally sign the macros, the certifcates aren't even in the
list from to choose. In fact, that dialog box is empty.
Is there any way to fix this lovely state of affairs so I can run my own
macros on my own spreadsheets with security set at High?

 

[Gord Dibben]

Are you trying to choose a certificate from the VBE Tools>Digital Signature or
from within Tools>Options>Security>Digital Signatures?

Are you logged in Administrator?

If not, what type of permissions do you have?


Gord Dibben MS Excel MVP

 

[Guest]

--
I know enuff to be dangerous.

Are you trying to choose a certificate from the VBE Tools>Digital Signature

Don't rightly know where this is.
or

 

[Gord Dibben]

With your workbook open hit Alt + F11 to go to the Visual Basic Editor.

CTRL + r to open the project explorer.

Select your workbook/project then Tools>Digital Signature and pick "Choose"

Do you have a choice of your selfcert signatures?

This is where you add a signature to a workbook.


Gord