Hi,
I have been given a digital certificate that is valid throughout my company so that users do not have to click Enable macros every time. However there seems to be two major issues:
- Often when I add the certificate (Tools / Digital Certificate) and then safe I get an error that the file has corrupted. Normally I get this on the save but sometimes I also get it on reopening the file. Removing the certificate and saving fixes the corruption. The certificate also seems to add some sheets to Excel that are not accessible.
- Further for files that have been successfully certified I often note that on changing the macro that the macro reverts back to the state of the original certification and does not include the latest changes.
I have extensively Googled but have not found any reference to this. Any advice as I still would like to distribute these files with the certificate.
regards,
Nils
I have been given a digital certificate that is valid throughout my company so that users do not have to click Enable macros every time. However there seems to be two major issues:
- Often when I add the certificate (Tools / Digital Certificate) and then safe I get an error that the file has corrupted. Normally I get this on the save but sometimes I also get it on reopening the file. Removing the certificate and saving fixes the corruption. The certificate also seems to add some sheets to Excel that are not accessible.
- Further for files that have been successfully certified I often note that on changing the macro that the macro reverts back to the state of the original certification and does not include the latest changes.
I have extensively Googled but have not found any reference to this. Any advice as I still would like to distribute these files with the certificate.
regards,
Nils