Dear Friends,
Anyone have code for stop user to access excel file after certain date.
Dear Friends,
Anyone have code for stop user to access excel file after certain date.
Take a look here: http://vbaexpress.com/kb/getarticle.php?kb_id=475
Regards
Paul Ked
Semper in excretia sumus; solum profundum variat.
Dear Paul,
The example is good but i would like fix the end date as shown below
Private Sub Workbook_Open()
Dim Enddate As Date
Enddate 18/10/2007 22:15
If Format(Now) = Enddate Then
MsgBox "Sorry, you can not access this file anymore"
End Sub
regards
Is this any better http://www.cpearson.com/Excel/WorkbookTimeBomb.aspx
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
XLD,
It is good.
Thanks