Look in the ThisWorkbook module right window for workbook_close

--
Don Guillett
SalesAid Software

"Nigel" wrote in message
...
Hi,

Can you run a macro when you close a workbook or do you have do this
through
a button? i konw you can run a macro on workbook open but i need it the
other
way round.
if you can't, can you prevent the workbook being closed via the red crox
in
the corner to force use of the button?

thanks in advance,



Nigel