Unprotect the sheet, highlight the whole sheet, right click, 'Format cells',
click 'Protection', uncheck 'Locked' OK
Edit as required and reverse the procedure
Regards,
Alan
"Kainoa" wrote in
message ...

I believe I'm fairly decent at programming in excel, but I can't figure
out this problem. I've created a spreadsheet with a lot of accounting
data on it (billing, payments history, etc.). I've protected the
entire sheet, but sometimes I need to go back in and change one cell. I
want to keep the rest of the sheet protected so I don't affect any other
numbers, but unlock the cell I'm interested in. I know that this is
possible in Lotus, but I can't find a way to do this in excel. If
anyone has some answers I would greatly appreciate it. Thanks in
advance.


--
Kainoa
------------------------------------------------------------------------
Kainoa's Profile:
http://www.excelforum.com/member.php...o&userid=28856
View this thread: http://www.excelforum.com/showthread...hreadid=486055