Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
hi again,
follow up: this code will delete all data in the file after 30 days you can add more sheets if you need. you can increase/decrease the number of days if you like. -----Original Message----- in the on open event you can put a timer if date()=now()+30 then sheets("sheet1").select cells.select Selection.ClearContents end if range("A1").formulaR1C1 = "the data in this file has been delete because it is out of date." classic virus -----Original Message----- I have a workbook that I send out to third parties, I want to limit its use either by time or number of times opened- is this possible? I want to guard against out of date data being in circulation. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |