Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet End Date
Can I write something into a spreadsheet so that it will only work for a set
period of time? TIA Michele |
#2
|
|||
|
|||
Try this in the Thisworkbook module
It will only work if the user Enable the macro's Private Sub Workbook_Open() If Date DateSerial(2005, 1, 22) Then ThisWorkbook.Close False End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "mjh" wrote in message ... Can I write something into a spreadsheet so that it will only work for a set period of time? TIA Michele |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Detecting Oldest Date On Spreadsheet | Excel Discussion (Misc queries) | |||
How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |