Limiting input by date

N

NEHicks

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.
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update date & time in a cell only when worksheet is changed 6
Date Range Formula Question - HELP! 3
Date & Day of Week 2
copying & incrementing formulae across open worksheets 4
Copy sheet 2
Running Sum of cell in many spreadsheets 1
renaming worksheets by date value 3
Will Macro before a Function like Now() ?? 2

Top