|
|
#4
04-07-2014, 11:22 PM
|
||||
|
||||
Presumbaly, you also won't want people inputting anything on 30 February - ever - or 29 February in most years...
The only way you can conditionally display/hide such rows (which doesn't stop people inputting data into them) or add/delete such rows (which does stop people inputting data into them) is via a macro. Such a macro can be tied to workbook opening, so that it checks the date and adds/deletes rows as applicable.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Find and Delete Rows based on a range | damaniam | Excel Programming | 2 | 03-12-2014 06:06 AM |
 Match information from 2 different columns
|
gbaker | Excel | 2 | 08-18-2012 06:07 PM |
|
Automatically inserting information into report
|
joughin | Word | 3 | 05-15-2012 09:12 PM |
| how to create two columns based on a certain criterior from the original two column? | where_pc | Excel | 3 | 06-13-2011 10:39 AM |
|
Add/Delete data in a Document based on User info
|
vishal17 | Word | 5 | 04-14-2011 05:02 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode