LinkBack URL
About LinkBacks
dear experts , how do i put a time lock or a count-down timer on my excel spreadsheet so that once the time reach, the excel cannot be opened or used.
please guide or teach me. please help
dear experts , how do i put a time lock or a count-down timer on my excel spreadsheet so that once the time reach, the excel cannot be opened or used.
please guide or teach me. please help
something like:
Formula:
Private Sub Workbook_Open()
If Now() > DateValue("20/09/2019") Then
MsgBox ("You can't use this file. File expired on: 20/09/2019.")
ThisWorkbook.Close
End If
End Sub
of course it not prevent to open. It have to be open to get message that can't be used. And obviously only with macro on.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Thank u. how do i on the macro?
and where do i paste this portion?
sorry to trouble u, because its the first time i am using macro
Click Alt+F11, new window should open (VBA editor) and then paste it here:
Capture.JPG
thank u. manage to do it.
but sadly, if they put disable macros when they open the doc. the thing will still be able to open
Sure. As I said 'it is not prevent to open'.
If you want you can set password to open file. That's only solution in this matter, I think.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks