Yes it is, put the macro Workbook_BeforeClose.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Dim Answ As Integer

Answ = MsgBox("OK to close?", vbYesNo)

If Answ = vbNo Then
Cancel = True
End If

End Sub


-----Original Message-----
Is there any way I can get a macro to run automatically
everytime a user closes down the workbook?

Many thanks

KD
.