ExcelBanter - Spreadsheet End Date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Spreadsheet End Date (https://www.excelbanter.com/excel-discussion-misc-queries/4489-spreadsheet-end-date.html)

mjh

Spreadsheet End Date

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

TIA

Michele

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

--
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

All times are GMT +1. The time now is 05:00 PM.