Different color type for different users

[rpistor]

I am trying to build a shared workbook that will be accessed by different users via internet. In order to identify the user who has posted a particular information in one cell I would like to have a specific color type for that user (without him having the option to change the color). Is that possible, and if so how do you do that?

Thanks,
Ralph

[MSP77079]

This code on the code window of the worksheet will do the colors for you (if you know the windows login ids of the users).

But, I don't have a solution for part 2 of the question ... how to prevent them from changing the color again.

Please Login or Register  to view this content.

One thing you could consider is to deactivate the controls for changing font color. But, a determined hacker could always modify their toolbar and add those controls back again.

Another thing you could consider is locking the cell after each change. But, you would have to do that with a password, or, again, a determined hacker could figure that out pretty quickly. Then, you would need to also lock your VBAProject code so that no one could open the VBEditor and read the password. The downside of locking the cell after each change is that is would not allow someone to make 2 changes.

Maybe another idea would be simply to record each change in a very hidden worksheet. Just record which cell was changed and put their userid next to it. Again, if you lock the VB Project, most folks would have no idea there was a very hidden worksheet (although, again, a very determined hacker who really knows Excel could foil you even without knowing the password).

Hopefully someone else has a better idea.