Spreadsheet End Date

M

mjh

Can I write something into a spreadsheet so that it will only work for a set
period of time?

TIA

Michele
 
R

Ron de Bruin

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
 
Top