Event Trigger

Ok, I only one a particular workbook to stop working completely, never
to work again, on January 9, 2006 at 9:00, so I don't need the class
module.
OR it could stop working as soon as it is opened on Jan 9, 06. Either is
good for me.

*** Sent via Developersdex http://www.developersdex.com ***

In the workbook_open event of the workbook you could have code like

In the ThisWorkbook Code Module:

Private Sub Workbook_Open()
if date > DateValue("Jan 9, 2006") then
thisworkbook.close
end if
End sub

However, just disabling macros upon opening or changing the system clock
will defeat this protection mechanism - besides the fact that the user can
break into your code and remove it.

--
Regards,
Tom Ogilvy


"Martin Bentler" <mbentler@sympatico.ca> wrote in message
news:O0QvT1mAGHA.2156@TK2MSFTNGP11.phx.gbl...
>
>
> Ok, I only one a particular workbook to stop working completely, never
> to work again, on January 9, 2006 at 9:00, so I don't need the class
> module.
> OR it could stop working as soon as it is opened on Jan 9, 06. Either is
> good for me.
>
> *** Sent via Developersdex http://www.developersdex.com ***