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?
--
I know enuff to be dangerous.

Are you trying to choose a certificate from the VBE ToolsDigital Signature or
from within ToolsOptionsSecurityDigital Signatures?

Are you logged in Administrator?

If not, what type of permissions do you have?


Gord Dibben MS Excel MVP

On Wed, 2 May 2007 05:59:01 -0700, RealGomer
wrote:

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?

--
I know enuff to be dangerous.


"Gord Dibben" wrote:

Are you trying to choose a certificate from the VBE ToolsDigital Signature
Don't rightly know where this is.
or
from within ToolsOptionsSecurityDigital Signatures? From here

Are you logged in Administrator? Yes

If not, what type of permissions do you have? n/a


Gord Dibben MS Excel MVP

On Wed, 2 May 2007 05:59:01 -0700, RealGomer
wrote:

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?

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 ToolsDigital Signature and pick "Choose"

Do you have a choice of your selfcert signatures?

This is where you add a signature to a workbook.


Gord


On Wed, 2 May 2007 13:52:00 -0700, RealGomer
wrote:

Are you trying to choose a certificate from the VBE ToolsDigital Signature


Don't rightly know where this is.