Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Assuming your spreadsheet will be password protected with all cells
hidden......I always insert a column on the left, insert the formula '=today()' then identify a cell which drives much of the information and add the fomula =if('the cell with =today() in it''the date in numbers you want the sheet to stop working',"") i.e. if today's date is greater than the preset date for the sheet to cease functioning then return blank data in the cell in which the formula appears. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
how to make a checkbox usable for users to "check" it? | Excel Discussion (Misc queries) | |||
make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
In EXCEL2000, How can I copy a file and make it usable in MS WORK | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) |