N
nightshift12
what i am trying to do is set up a booby trap with an excel workbook s
that the critical worksheet will disappear when a macro is run. i hav
created the macro to accomplish this. what i need to know if there is
way using the date function and an "if" statement to have the macro ru
automatically when the condition is met.
eg: if today()>20 june o4, then run the macro
is this possible, or is there another way to accomplish this. ideally
would like to have the option of changing the condition such a
entering a later date. this is for a program i designed on my own fo
work, but do not want others to be able to access it in certai
situations. hence the booby trap.
Pete
that the critical worksheet will disappear when a macro is run. i hav
created the macro to accomplish this. what i need to know if there is
way using the date function and an "if" statement to have the macro ru
automatically when the condition is met.
eg: if today()>20 june o4, then run the macro
is this possible, or is there another way to accomplish this. ideally
would like to have the option of changing the condition such a
entering a later date. this is for a program i designed on my own fo
work, but do not want others to be able to access it in certai
situations. hence the booby trap.
Pete