View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
STEVE BELL STEVE BELL is offline
external usenet poster
 
Posts: 692
Default Why is my digital signature is being discarded?

Have you considered writing your code in a .xla (add-in) and sending that to
your people?
Or put the code in a standard workbook and have your people save it to their
xlStartUp folder.

Not sure if this will get past the certificate issue....

--
steveB

Remove "AYN" from email to respond
"Nadine" wrote in message
...
That's right. I wouldn't have made code to modify code, I'm too novice
for
that....
I guess installing the certificate on the users machine would do the
trick,
but i'll have
40 users world-wide starting next week , I wonder if that is going to be
doable. Won't they, if they are clever, be able to write their own code
under my certificate?
I hope for this sake there is another answer...

"ben" wrote:

If you don't know for sure then it's a good guess that it does not do so.
It's not a simple process to do. Have you tried installing the security
certificate on the users machine? They won't be able to write anything
with
it, their machine will just recognize it as trusted.

--
When you lose your mind, you free your life.


"Nadine" wrote:

Hmm. good question. does my code modify any code. not sure what you
mean by
that. In some cases I've done: Application.ScreenUpdating = False.
Do you think that would do it?
I did lock the project for viewing, but the problem still happened.

"ben" wrote:

Two questions.
Does your code modify any code? and also try locking your project for
viewing.

--
When you lose your mind, you free your life.


"Nadine" wrote:

I have some simple VBA code in an excel file and when another user
does basic data entry in that file, he gets a information message:
You have
modified a signed project. You do not have the correct key to sign
this
project the signature will be discarded. But he isn't doing any
code work,
just data entry. Why is this happening?