>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
[quoted text clipped - 12 lines]
>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?

Signature
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
> from within Tools>Options>Security>Digital Signatures? From here
>
[quoted text clipped - 20 lines]
> >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 - 02 May 2007 22:22 GMT
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
>> Are you trying to choose a certificate from the VBE Tools>Digital Signature
>Don't rightly know where this is.