Delete file from a date

[hoyos]

is there a way to delete or restrict a file by using VBA code from a certain date when it's opened? I need to make users use a new file

 

[Yongle]

Many things you could do.
How about auto-closing file
After date in parenthesis file is closed automatically if user does not know password (password = "ok")

In ThisWorkbook module

Private Sub Workbook_Open()

If Date > CDate("22/05/2018") Then
    If InputBox("Password", "Workbook Expired") <> "ok" Then
        ThisWorkbook.Close False
    End If
End If

End Sub

Add the above code, save, close and re-open the file to test

How is your expiry date determined?

 

[Yongle]

You may be interested in reading this page from Chip Pearson's site

 

[hoyos]

Many thanks that works ok.