I was wondering if someone knows of a macro that will cause the current excel
that is in use to be deleted if a certain condition is not met
or to lock the file so it cant be used unless a condition is met.

For instance say if a certain password is not entered in a hidden cell
every 3 months, the file would not be able to be open or used ( IT WOULDLOCK
THEM OUT)

Let me know
Thanks


--
crunchin numbers

No matter what you do you can't stop someone opening a Workbook with Macros
disabled so no Macro solution would work.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"belvy123" wrote in message
...
I was wondering if someone knows of a macro that will cause the current
excel
that is in use to be deleted if a certain condition is not met
or to lock the file so it cant be used unless a condition is met.

For instance say if a certain password is not entered in a hidden cell
every 3 months, the file would not be able to be open or used ( IT
WOULDLOCK
THEM OUT)

Let me know
Thanks


--
crunchin numbers