Is it possible when an entire sheet is protected if a user was to click on a
specific cell(A65) to temprarily unlock let them edit it and lock it back? if
so, can someone give me and example on how i might be able to do this.

The reason i need to lock it and unlock it is because im using the protect
worksheet fuction..so it locks my whole worksheet but i need some of the
fields to stay unlocked all the time.

Hello Reggie,

Before protecting your worksheet, select the the cells that will remain
unlocked. Select FORMAT | CELLS...
Click the PROTECTION tab
Click the LOCKED checkbox to clear it

This will allow only the cells you want the user to change to remain
unprotected, after you enable the worksheet protection.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=495370

Select the cells you want to be editable then:

Format Cells Protection Uncheck "locked" checkbox

Only locked cells are protected when the sheet is protected.

Tim.

--
Tim Williams
Palo Alto, CA


"Reggie" wrote in message
...
Is it possible when an entire sheet is protected if a user was to click on
a
specific cell(A65) to temprarily unlock let them edit it and lock it back?
if
so, can someone give me and example on how i might be able to do this.

The reason i need to lock it and unlock it is because im using the protect
worksheet fuction..so it locks my whole worksheet but i need some of the
fields to stay unlocked all the time.