View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oscar oscar is offline
external usenet poster
 
Posts: 55
Default Auto-lock a cell once it's updated

Hi.

I have a shared workbook that is used by two processors. On column A I have
a drop down that allows the processors to select Yes or No. I would like the
cell that they update to automatically lock by not allowing the processors to
go back and change what they already selected. If they try to change the
info, I would like it to prompt a password request in order to make a change
on that cell. If this is possible please let me know.

Thanks