disable macro/code after date & time
in [Programming]
|
Prev: Copy a Textbox to a range on different worksheet
Next: Email Last row to an email address in the last active cell
From: J.W. Aldridge on 20 Apr 2010 11:57 I have a code/macro that runs great. After July 1, 2010, I no longer want it to run (even if called). Any code that I can insert?
From: J.W. Aldridge on 20 Apr 2010 12:01 Or better yet. On workbook open.... close in 10 seconds if after date x. If too complicated, then disable calculations after date x.
From: Paul C on 20 Apr 2010 12:54 Chip Pearson's site has a section on this topic that should help you http://www.cpearson.com/excel/workbooktimebomb.aspx -- If this helps, please remember to click yes. "J.W. Aldridge" wrote: > > > Or better yet. On workbook open.... close in 10 seconds if after date > x. > > If too complicated, then disable calculations after date x. > > . >
From: Simon Lloyd on 20 Apr 2010 13:04 There is code to do that but it relies on the user enabling macros, you would have to force the use of macro's first. J . W . A l d r i d g e ; 7 0 3 8 8 8 W r o t e : > I have a code/macro that runs great. After July 1, 2010, I no longer want it to run (even if called). Any code that I can insert? -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196949 http://www.thecodecage.com/forumz
From: J.W. Aldridge on 20 Apr 2010 13:35
Thanx!!! |