Time limit on macro

[Julie]

Hi - here's a strange question:

I have a macro that I want to automatically disable on a
certain date, so that it is no longer usable. Is there a
way to do this in the code?

Thanks

 

[Dave Lett]

Hi Julie,

You can use something like the following:

If Date < "8/4/2004" Then
'''run your routine
End If

However, if the user manually changes the system date, then the routine can
be run.

HTH,
Dave

 

[Julie]

THANK YOU!!!

-----Original Message-----
Hi Julie,

You can use something like the following:

If Date < "8/4/2004" Then
'''run your routine
End If

However, if the user manually changes the system date, then the routine can
be run.

HTH,
Dave




.

 

[Jezebel]

The line would be better written:

If Date < #8/4/2004# then

Otherwise you may fall foul of some users' regional settings.