Digital Signature being dropped
I'm having a problem with Excel dropping a signature. The user runs a macro
that deletes existing sheets and re-creates them from a hidden 'template'
sheet. It appears that the deleting/re-creating of sheets makes Excel think
the code base has changed therefore it is dropping the signature.
I don't have an easy way around this by changing my code. Any ideas on how
to make Excel keep the signature? Or ways to programmatically reconnect the
signature?
|