Sam,

You can use the Workbook_BeforeClose event procedure, or you can
name a macro Auto_Close.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Sam Dickins" wrote in
message ...
hello people,

in my workbook code, I can make things happen when the
book starts up using...
Private Sub Workbook_Open()

It may be a simple question, but how do I do the opposite
for when the workbook closes?

thanks a lot you clever folk,

Sam