Disable printing and macros from specific date

[beegeebluebo]

I want to ensure uses a new version of my spreadsheet at a later date so I want to:

1
Prevent printing from a specific date

2
Prevent macro from running from a specific date.

Yes perhaps the user could change the system clock but then I would know that they must have done that if I see the output.

Is it possible?

Thanks

[SamT]

[vba]
Private Sub Workbook_Open()
If Date => Someday Then Me.Close
End Sub
[/vba]

[beegeebluebo]

Thanks very much

[mdmackillop]

You could also refer to Document Properties
[VBA]
Private Sub Workbook_Open()
If Date - ActiveWorkbook.BuiltinDocumentProperties("Creation date") > 7 Then
Me.Close
End If
End Sub

[/VBA]

[beegeebluebo]

You could also refer to Document Properties
[vba]
Private Sub Workbook_Open()
If Date - ActiveWorkbook.BuiltinDocumentProperties("Creation date") > 7 Then
Me.Close
End If
End Sub

[/vba]

Thanks, bu if they use Save as don't they get a new Creation Date?