Unlocking and locking a specific cell

[Reggie]

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.

 

[Leith Ross]

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

 

[Tim Williams]

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.