Stop all macros when closing a workbook?

[L2B]

Hi,
I want to stop all macros working when I close a workbook. I have a loop that works every 5 minutes and if you close the work book with out interupting the code it re-opens. Also is the there a simple way to stop code when it is running or is there a status bar saying which macros are running in the background?

So many thanks for your help?

Liz

[MrShorty]

I believe what you want is a Workbook_close procedure that will terminate the subroutine. I don't know that much about them, the only time I used them was once back when I had 5.0 and they called them Auto_Open and Auto_Close procedures (which I believe still work). VBA Help doesn't seem to have much info on them, but I think it's as simple as defiining a procedure in a Module in that workbook that's called Workbook_Close(). Hopefully someone more familiar with these auto procedures will chime in.