Making a macro run when the user closes a workbook

[Nicke]

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