Hide a personal ID code in a cell

Saa62 · Apr 20th, 2002, 07:14 PM

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 · Apr 20th, 2002, 09:37 PM

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 · Apr 21st, 2002, 02:41 AM

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 · Apr 21st, 2002, 04:01 PM

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

Apr 20th, 2002, 09:37 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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. __________________ It's never too late to learn something new. Ricky

Apr 21st, 2002, 02:41 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 07:14 PM	#1
Saa62 New Member Join Date: Mar 2002 Posts: 20	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

Apr 21st, 2002, 04:01 PM	#4
Saa62 New Member Join Date: Mar 2002 Posts: 20	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