Re: $$Excel-Macros$$ Need help to complete a Excel Model..

2010-04-23 Thread vinu
Hello Team, I got the code here http://www.atlaspm.com/faqxlselfclose.html could you please edit the same as to ful fil my requirements below. And it should pomp up msg box at 45 min sayin "This test will over in 15 min" lik that. Thanks. Vinu vinu wrote: > Hello Friends, > > I build a model

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

2010-04-23 Thread vinu
Hi Paul, I got the code similar to this, but dont exatly how to edit this as per my requirements. http://www.atlaspm.com/faqxlselfclose.html As I said in the first post, once he clik on hyperlink(i.e., in 1st sheet), it will count till 60 Minutes, and before 15 min it shud remind him. after 60

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

2010-04-23 Thread Paul Schreiner
That's actually very tricky to do, and has all kinds of potential for circumventing it. The problem is that when VBA macros run, they usually have "control" of Excel. they don't run in "background". that means that a normal macro that runs and monitors the time wouldn't allow the person TAKING th