pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Hi!
In one of the workbook, i use a code like this...when it reaches expiry date it gvies pop up...& then closes it...so there is no way (as for me I dont know a way) to stop it from closing as u all know how fast the macro is....I was trying to re-open and change the setting but it does not allow me to do anything now as it has expired. Is there a way i can make changes to this macro from another code or something???
Please advice if you've any idea....!!!
In one of the workbook, i use a code like this...when it reaches expiry date it gvies pop up...& then closes it...so there is no way (as for me I dont know a way) to stop it from closing as u all know how fast the macro is....I was trying to re-open and change the setting but it does not allow me to do anything now as it has expired. Is there a way i can make changes to this macro from another code or something???
Please advice if you've any idea....!!!
Code:
Sub Auto_Open()
Dim exdate As Date
exdate = "7/30/2010"
If Date > exdate Then
MsgBox ("You have reached end of your trial period")
ActiveWorkbook.Close
End If
MsgBox ("You have " & exdate - Date & "Days left")
End Sub