View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MSweetG222 MSweetG222 is offline
external usenet poster
 
Posts: 158
Default 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