Outdated macro self certificate

  • Thread starter Thread starter GEORGE HUMPHRIES
  • Start date Start date
G

GEORGE HUMPHRIES

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 Tools>Digital Signature>Choose

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


Gord Dibben MS Excel MVP
 
Thanks for the reply.

Personal self certificate.

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

George Humphries
 
Back
Top