Run Auto Close when Excel Closes
 

I have in several documents an auto_close macro that runs when you click the
document closed individually or when you choose the command to Close All.
However is there an event or a Sub or module, I can use to run the
auto_close macro when i click on the button to close excel itself. When i do
so, the auto close macro will run, but only for the active workbook, all
other workbooks disregard the auto macro. I have event procedures, for
beforeworkbookclose at the application level enabled but i can not quite seem
to get them functioning correctly for this particular instance.

Ben