Why don't you just put in the BeforeClose of the particular workbook?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"btee" wrote in message
...
I would like to run a macro whenever a workbook is closed (with or without
saving) in Excel. I tried to do this by placing the code in the
Workbook_BeforeClose in Personal.xls and making it Public. It didn't
work!

Is there anyway to do this? I'm aware of Auto_Close, but I want this to
happen on the Workbook, not App.

Thanks.