LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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...


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want excel to input data in a cell from multiple cell choices Pam Excel Worksheet Functions 7 March 11th 09 07:52 PM
Preventing user input for individual cells Michael.Tarnowski Excel Worksheet Functions 3 January 30th 09 12:05 AM
data input into cell a1 drives c1 data gathered from a list petlover Charts and Charting in Excel 0 June 11th 07 10:23 PM
refilling data in same cell after user input in another cell H. Singh Excel Discussion (Misc queries) 7 April 24th 07 12:48 PM
Data input to one cell? Potaroo New Users to Excel 1 April 17th 07 12:38 AM


All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"