"You have modified a signed project . . ."

[Thomas McLeod]

Hello,

My users keep getting a dialog that says "You have modified a signed
project, the signature will be discarded" everytime AutoRecover tries to
save a backup in Excel 2003 SP1. The users can't lower their macro security
and I've tried everything to fix this problem. If I can't get a solution I
will need to distribute a signing certificate with a private key with the
application.

Kind of defeats the purpose of macro security, doesn't it?

Thomas

 

[Michael Herzfeld]

Hi Thomas. The only reason you should be getting this alert is if the VB
project of your solution has been modified. I assume your users aren't
manually opening VBE and changing the project, so most likely your
solution itself is doing something that dirties the project. For
example, deleting a worksheet in Excel will dirty the project, as will
adding an ActiveX control. If it is your solution itself that is causing
the problem and the functionality cannot be changed, the only
recommendation I have is to not sign it and put it in a trusted location
instead.

Michael Herzfeld
Office Programmability Test Team


-----Original Message-----
From: Thomas McLeod [mailto:[email protected]]
Posted At: Tuesday, July 19, 2005 9:12 AM
Posted To: microsoft.public.office.developer.vba
Conversation: "You have modified a signed project . . ."
Subject: "You have modified a signed project . . ."

Hello,

My users keep getting a dialog that says "You have modified a signed
project, the signature will be discarded" everytime AutoRecover tries to
save a backup in Excel 2003 SP1. The users can't lower their macro
security
and I've tried everything to fix this problem. If I can't get a solution
I
will need to distribute a signing certificate with a private key with
the
application.

Kind of defeats the purpose of macro security, doesn't it?

Thomas