| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
![PaddyMac[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
