Automatic Disable vba code after specific timeframe

[Sharyanshgoyal]

Hi,

I need a automatic vba code to disable the existing vba file after specific timeframe and specific date.

Thanks

 

[JLGWhiz]

After and on July 1 this year, the code would not run past the first line because the current date would be greater han the criteria date.

Sub t()
If Date >= #7/1/2019# Then Exit Sub
'Your regular code here
End Sub

Date is current date
The date with the pound symbols is the criteria date. The pound symbols make it date literal so it will be the correct data type.

 

[Sharyanshgoyal]

After and on July 1 this year, the code would not run past the first line because the current date would be greater han the criteria date.

Sub t()
If Date >= #7/1/2019# Then Exit Sub
'Your regular code here
End Sub

Date is current date
The date with the pound symbols is the criteria date. The pound symbols make it date literal so it will be the correct data type.

Dear JLGWhiz

Thanks for your quick reply. I'm new in the world of vba coding. Request if you can also set a message box that will reflect after the expiration date for the user.

 

[JLGWhiz]

Sub t()
If Date >= #5/28/2019# Then
     MsgBox "Code expired on 5/28/2019", vbInformation, "CODE EXPIRED'"
     Exit Sub
End If
'Your regular code here
End Sub