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

--
Message posted from http://www.ExcelForum.com