Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically perform action when closing Excel Worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically perform action when closing Excel Worksheet
hi.
there isn't a workbook_close event. there is a workbook_beforeclose event change the sub title to Sub WorkBook_BeforeClose(Cancel As Boolean) regards FSt1 "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically perform action when closing Excel Worksheet
Jacob
It works perfectly. Many thanks! Kindest regards PaddyMac "Jacob Skaria" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically perform action when closing Excel Worksheet
Perfect!
Thank you so much! Kindest regards PaddyMac "FSt1" wrote: hi. there isn't a workbook_close event. there is a workbook_beforeclose event change the sub title to Sub WorkBook_BeforeClose(Cancel As Boolean) regards FSt1 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to perform action on range | Excel Programming | |||
Perform action on every workbook in a directory | Excel Programming | |||
How to 'Click and then perform action' | Excel Programming | |||
How to perform action in all worksheets | Excel Programming | |||
Perform action when cell is clicked | Excel Programming |