Hide a personal ID code in a cell

[Saa62]

I have a worksheet that gets reviewed by various people. I am looking for a way that after a person reviews the worksheet that they can type in an assigned ID code to varify it has been reviewed, but I don't want the ID to be visable(maybe ******) to the average user. Security does not have to be real high just enough to attempt to keep everybody honest. Any suggestions

Thanks

Scott

 

[Ricky Morris]

Highlight the cells you want the user the enter the ID code and Select Format > Cells > Protection tab. Uncheck Locked and check Hidden. Click OK. Format the cells with a non-character font such as windings. Password protect the worksheet by selecting Tools > Protection > Protect Sheet and enter a password.

 

[Jack in the UK]

i often add Excel security is very basic and takes advanced users a few seconds to bust it open, some tricks are harder but not impossible if hard we rip the data so dont even need to get into it,

Just so you know im not posting this to be a fool, just warning NOTHING is scure and so you need to be awair that no one is protecting you.

I can more or less get into ANY files passwords now also, but takes time... but yo will stop the idiots that have the odd look i guess.

Take care... no secure fix bar do not give the data that you dont want guys to see in the first palce.

 

[Saa62]

The hidden check box in properties was what I needed. Thanks for the help.

I do realize that security is not much of a reality with excel, but it is good enough for what I need in this situation.

Thanks again.

Scott