On the VBE editor,

double click "ThisWorbook"

then use this.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
your macro here
End Sub

Regards,

Cesar Zapata

"KD" wrote in message
...
Is there any way I can get a macro to run automatically
everytime a user closes down the workbook?

Many thanks

KD