Sub Auto_Close()
'your code here
End Sub

that is how i do it :-)
(the auto_close makes it run at close)
"Donnie" wrote:

How do I phrase the VBA to run a macro on closing the spreadsheet?

Any ideas?

Thanks
Donnie