| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limiting input by date
Is there a way to stop a worksheet from accepting data after a certain date?
I have a workbook with 26 worksheets, 1 for each pay period. I would like to add some kind of date limit so that the users of the workbook must go to the next pay period if it is after the date that "sheet" closed. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limiting input by date
You can use
Data | Validation Just set your end date to be equal to some cell on that sheet where you input the close date. -- HTH... Jim Thomlinson "NEHicks" wrote: Is there a way to stop a worksheet from accepting data after a certain date? I have a workbook with 26 worksheets, 1 for each pay period. I would like to add some kind of date limit so that the users of the workbook must go to the next pay period if it is after the date that "sheet" closed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How input today's date and keep that date | Excel Worksheet Functions | |||
| input a date or update it based on date in another cell | New Users to Excel | |||
| automatically input date? | Excel Discussion (Misc queries) | |||
| date input | Excel Discussion (Misc queries) | |||
| date year input | Excel Discussion (Misc queries) | |||
Linear Mode
