Ending application on time macro

**phil2006** · 09-21-2008, 05:27 PM

Hi,

I have the following code:

Please Login or Register  to view this content.

Unfortunately I cannot get this macro to end. I have tried inserting an end if macro attached to a button on my sheet but the ontime seems to override it and still won't stop. Any help in ending this macro (ideally using a button on my sheet) without having to exit the whole workbook would be most appreciated!

Thanks very much in advance,

Phil

**dominicb** · 09-21-2008, 05:49 PM

Good evening phil2006

Originally Posted by phil2006

Any help in ending this macro (ideally using a button on my sheet) without having to exit the whole workbook would be most appreciated

Something like this should, when called, stop the macro nicely :

Please Login or Register  to view this content.

HTH

DominicB

**phil2006** · 09-21-2008, 06:05 PM

Thanks very much Dominic! I knew it would be something very quick and easy for someone in the know! Using this comes up with a run time error '1004' though. This isn't a big problem for this sheet as the key for me was to end the ontime application quickly.

Thanks very much again,

Phil