ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Trust Certificate/Digital Signature "Breaks" Upon Addition of Shee (https://www.excelbanter.com/excel-programming/416508-trust-certificate-digital-signature-breaks-upon-addition-shee.html)

MSweetG222

Trust Certificate/Digital Signature "Breaks" Upon Addition of Shee
 
Hello all,

I have written a macro (which is in a module) and I have signed it with a
VeriSign digital signature/trusted certificate. There are NO macros behind
any of the worksheets or in the "ThisWorkbook" module.

Every time I right click on a sheet to make a copy...it breaks the digital
signature. I have tried it with a very simple macro (see below) and it still
happens.

Sub Test
Msgbox "Hello World"
End Sub

I have tried locking the VBA and it still happens.

I want to give the workbook to others, however if it is going to ask for my
digial signature everytime they make a copy of a sheet... that will not work.

What can I do to keep this from happening?

Thank you for your help
--
Thx
MSweetG222



All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com