Boxes

Hi Bradley

Thanks for your question

Can you clarify your question for me. Why do you want the message box to appear before closing your worksheet? What options do you want it to present

Thanks

Stephen

Hi Bradley,

Thank you for your question.

Please follow these instructions:

1. Open the workbook first.

2. Then Alt + F11 on the keyboard.

3. In the Project Explorer window on left of screen, find the VBAProject with your workbook name and expand it if necessary using the + symbol.

4. From the list of Objects double click on workbook.

5. A new window appears on the right hand side.

6. From the first drop down box at the top choose Workbook.

7. From the second combo box to the right, choose BeforeClose.

8. The following should then appear:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

msgbox "Enjoy your evening"

End Sub

9. Between Private Sub and End sub type the following as shown above.

10. Close the VBA window using the red X and everytime you close the workbook the message appears.

I hope this answers your question. Let me know.

Regards

Simon