I asked this a while back without success (but thank you for trying
Gord) - but it's so so so valuable that I'm trying again in case new
eyes catch this. I actually am not on a new machine, but reinstalled
Win XP and Office 2003 which I run in Medium Security. But first I
backed up the certificate directory to C:\Documents and
Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My
\Certificates

Can these backups possibly be reused? Or can I create a new
certificate that still satisifies workbooks that referenced the old
cert? By the second question I mean, I have a ton of workbooks that
reference MyRundgrenSelfCert. That allowed my [preupgrade] machine to
"trust" the macros and skip the warning prompt if I had "stamped" them
with MyRundgrenSelfCert. Now those workbooks still look for
MyRundgrenSelfCert in order to skip the warning. Can I give them what
they want, without having to edit and resave the workbook files?
Because even though I restored the pre-upgrade's C:\Documents and
Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My
\Certificates, I get the warning when I open files that reference
MyRundgrenSelfCert.

Can I possibly get rid of the warning, without having to reassign the
workbooks' and resave them? I really really really hate to have to
update the file dates merely for this purpose.

This confounds my admittedly feeble grasp of the concept of certificates to begin with. Does an official issuing agency make one that can be passed out to multiple users? If so, don't you get to do that with one that you create? (Much less, can't I pass one out to mySELF after a backup! That would eliminate those irritating prompts on .XLSs and .MDBs.)

I would hate editing and resaving files so they point to a new certificate. That would destroy file dates which are valuable history.

On Wednesday, January 4, 2012 7:26:00 PM UTC-6, Cartman wrote:
I asked this a while back without success (but thank you for trying
Gord) - but it's so so so valuable that I'm trying again in case new
eyes catch this. I actually am not on a new machine, but reinstalled
Win XP and Office 2003 which I run in Medium Security. But first I
backed up the certificate directory to C:\Documents and
Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My
\Certificates

Can these backups possibly be reused? Or can I create a new
certificate that still satisifies workbooks that referenced the old
cert? By the second question I mean, I have a ton of workbooks that
reference MyRundgrenSelfCert. That allowed my [preupgrade] machine to
"trust" the macros and skip the warning prompt if I had "stamped" them
with MyRundgrenSelfCert. Now those workbooks still look for
MyRundgrenSelfCert in order to skip the warning. Can I give them what
they want, without having to edit and resave the workbook files?
Because even though I restored the pre-upgrade's C:\Documents and
Settings\MyNameHere\Application Data\Microsoft\SystemCertificates\My
\Certificates, I get the warning when I open files that reference
MyRundgrenSelfCert.

Can I possibly get rid of the warning, without having to reassign the
workbooks' and resave them? I really really really hate to have to
update the file dates merely for this purpose.