View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kimti Kimti is offline
external usenet poster
 
Posts: 38
Default Protecting worksheet

There was one mistake in my questions. Please read data instead of date.
I mean to say that if any one enters a data in a blank unlocked cell and
save the file, that cell has to be locked.

"Kimti" wrote:

Hi,
I have a sheet with some protected cell, which allows others to enters some
date on the unlocked cells. I would like to see those unlocked cells to be
locked as soon as some one enters the date and saves the file.