Automatically perform action when closing Excel Worksheet
Double click 'This Workbook' and see the drop downs on the right code module
to see the workbook events...
'Remove your code and copy paste the below and try
Private Sub Workbook_BeforeClose(Cancel As Boolean)
MsgBox "This Worksheet is now closing"
End Sub
If this post helps click Yes
---------------
Jacob Skaria
"PaddyMac" wrote:
I want a message box to come up when I close an Excel worksheet
In the "This Workbook" module I have inserted the following code
Private Sub Workbook_Close()
MsgBox "This Worksheet is now closing"
End Sub
When I click on F5 in Visual Basic Editor, it works, but when I close the
document, it doesn't.
Any ideas?
Many thanks
Kindest regards
PaddyMac
|