Time Lapsed code to delete code !

[Eurekaonide]

Hi All

What sort of code would I need to write which could be triggered by a date and effectively delete VBA Code?

I have something that needs to run till a said time and then be deleted as it could interfere with other codes running after this time.

 

[Ruddles]

Call TimePlease

 

[Ruddles]

Or just put the code directly in your Workbook_Open event handler.

(You don't need that Else: Exit Sub - it isn't actually doing anything.)

 

[Eurekaonide]

OK another question, I thought I ahd this sorted but it doesn't seem to be working

I want the code to action on or after a set date so I had the following;

If Date = DateValue <= ("30/06/2011") Then

But it doesnt seem to work, it either deletes it before the time or if I put the date to today or to a past date it doesn't delete it, am I going mad?? I ahve used both the < and > signs and it doesn't appear to make a difference

 

[Ruddles]

If Date >= DateValue("30/06/2011") Then

 

[Ruddles]

<deleted>