An Excel file that some people use has started generating the following message when we try getting into it: "file contains macros with an expired or revoked signature". It also said that we were using the High Security settings, so the macros will be disabled.
I am the Assistant Network Administrator. The person who wrote the certificate with the digital signature and I checked. Sure enough, the signature expired 7-26-06. Neither of us could figure out how to change the expiration date for the signature.
A work-around is to change the Security Setting from High to Medium and then Enable Macros, but we don't want to change everyone's security setting to Medium and have them enable macros. We want to change the expiration date of the digital signature for the macro and leave the Security Setting at High. Does anyone know how we can do this? Thanks!
I am the Assistant Network Administrator. The person who wrote the certificate with the digital signature and I checked. Sure enough, the signature expired 7-26-06. Neither of us could figure out how to change the expiration date for the signature.
A work-around is to change the Security Setting from High to Medium and then Enable Macros, but we don't want to change everyone's security setting to Medium and have them enable macros. We want to change the expiration date of the digital signature for the macro and leave the Security Setting at High. Does anyone know how we can do this? Thanks!