View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
R R is offline
external usenet poster
 
Posts: 4
Default Preventing data input until a particular cell is used

Hi all,

Apologies if I have missed the obvious, but I need to prevent further data
input in a simple spreadsheet until a particular cell is completed.

There is a cell named "Week Ending" which needs the date for the next week
ending (Usually a Sunday) completed in the adjacent clear cell.
The person entering data into other cells *always* forgets to enter the date
in that cell and just gets on with sorting out a rota for employees, prints
the sheet, and then notices the date is wrong so has to do it all again or
pen it in.

How do I prevent them entering other data until the date is entered into
that cell?

Excel in Office 2007 if it matters...