Making a macro run when the user closes a workbook

N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a macro only work on certain files 2
Making a field compulsary before user leaves sheet 3
Word macro that can call cells out of Excel for a find and replace 0
Can't delete sheets 8
Run time error 2
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Problem with before close 1
Check each sheet for Auto-filtering and switch it off 6

Top