Locking hidden rows

Hayesk · Apr 9th, 2002, 08:30 PM

I have hidden rows on a worksheet and would like to lock these, so they cannot be unhidden by others.

Your advice on how to do this would be much appreciated. Thanks.

kinkyparamour · Apr 9th, 2002, 08:35 PM

Password protect your workbook. Cells are locked by default but you have to protect the workbook or worksheet in order to take advantage of it......

Denny

Hayesk · Apr 9th, 2002, 08:47 PM

Thanks Denny

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

Apr 9th, 2002, 08:30 PM	#1
Hayesk New Member Join Date: Mar 2002 Location: Japan Posts: 30	I have hidden rows on a worksheet and would like to lock these, so they cannot be unhidden by others. Your advice on how to do this would be much appreciated. Thanks.

Apr 9th, 2002, 08:35 PM	#2
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	Password protect your workbook. Cells are locked by default but you have to protect the workbook or worksheet in order to take advantage of it...... Denny

Apr 9th, 2002, 08:47 PM	#3
Hayesk New Member Join Date: Mar 2002 Location: Japan Posts: 30	Thanks Denny