I have various worksheets which I have self certified the macros, but the
certificate expired on the 31st December 2007.

I have created a new certificate and tried to attach it to the work sheet
but, the work sheet still refers to the obsolete one when opening.

Anyone got any ideas or suggestions please?

I wrote a week or so back asking how to update my digital certificate which
had expired on 31st December 2007.

I have found the only way to proced is to resign with the new certificate
individually each of the macros in the spreadsheet.

As this amounted to nearly thirty macros it was a bit of a process.

I have several other spreadsheets which need updating, is there any way of
collectively resigning all the macros in a spreadsheet instead of
individually?

George Humphries

What type of digital certificate are you speaking of?

A personal one created by using the Office SelfCert tool or another type?

Whichever the case you should be able to assign a certificate to an entire
VBAProject by going to VBE and ToolsDigital SignatureChoose

For my personal use I have created a DS using selfcert and the above method
works fine.


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 00:52:40 -0000, "GEORGE HUMPHRIES"
wrote:

I wrote a week or so back asking how to update my digital certificate which
had expired on 31st December 2007.

I have found the only way to proced is to resign with the new certificate
individually each of the macros in the spreadsheet.

As this amounted to nearly thirty macros it was a bit of a process.

I have several other spreadsheets which need updating, is there any way of
collectively resigning all the macros in a spreadsheet instead of
individually?

George Humphries

Thanks for the reply.

Personal self certificate.

I'll try your suggestion on one of my other spreadsheets.

George Humphries

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
What type of digital certificate are you speaking of?

A personal one created by using the Office SelfCert tool or another type?

Whichever the case you should be able to assign a certificate to an entire
VBAProject by going to VBE and ToolsDigital SignatureChoose

For my personal use I have created a DS using selfcert and the above
method
works fine.


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 00:52:40 -0000, "GEORGE HUMPHRIES"
wrote:

I wrote a week or so back asking how to update my digital certificate
which
had expired on 31st December 2007.

I have found the only way to proced is to resign with the new certificate
individually each of the macros in the spreadsheet.

As this amounted to nearly thirty macros it was a bit of a process.

I have several other spreadsheets which need updating, is there any way of
collectively resigning all the macros in a spreadsheet instead of
individually?

George Humphries