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?

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?

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?

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?

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?

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?

If you've protected it then, it can't be modified programmatically either. Strange. I've seen Excel 97 (a known bug I believe) insert lines into a locked project's modules just by opening and closing
the workbook.

What version of Excel and SP are you and he using?

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.

MS 2002, SP1

"Gareth" wrote:

If you've protected it then, it can't be modified programmatically either. Strange. I've seen Excel 97 (a known bug I believe) insert lines into a locked project's modules just by opening and closing
the workbook.

What version of Excel and SP are you and he using?

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.