ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Digital Signature Issue (https://www.excelbanter.com/excel-programming/416291-digital-signature-issue.html)

MSweetG222

Digital Signature Issue
 
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 a 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. I have tried locking the VBA and it still happens.

Sub Test
Msgbox "Hello World"
End Sub

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

Why is it doing this and what can I do to keep this from happening?

Thank you for your help.
MSweetG222



All times are GMT +1. The time now is 11:15 AM.

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