run macro automatically

  • Thread starter Thread starter nightshift12
  • Start date Start date
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
 
There is no way to make this foolproof, as the user can easily disable
macros. But you can certainly put the macro in the Workbook_Open event:

If Date > DateValue("20-Jun-2004") Then ...

I don't think it's advisable to set booby traps for other users, though.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Run Macro when a condition is met 7
Run Macro on All Sheets Q 8
Don't re-run macro for five seconds...? 8
Excel Macro to automatically go to the right of the last colored cell 0
Record line number in macro where error occurs 4
run a macro in excel when moving data 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7

Back
Top