View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kainoa
 
Posts: n/a
Default Unprotecting a single cell


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