ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   disable macro/code after date & time (https://www.excelbanter.com/excel-programming/441837-disable-macro-code-after-date-time.html)

J.W. Aldridge

disable macro/code after date & time
 
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?


J.W. Aldridge

disable macro/code after date & time
 


Or better yet. On workbook open.... close in 10 seconds if after date
x.

Paul C

disable macro/code after date & time
 
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.

.


Simon Lloyd[_1341_]

disable macro/code after date & time
 

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. Aldridge;703888 Wrote:

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/sh...d.php?t=196949

http://www.thecodecage.com/forumz


J.W. Aldridge

disable macro/code after date & time
 
Thanx!!!


All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com