Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wish a message box to appear before closing an Excel Workbook,
however I have tried (in the "THIS WORKBOOK" object: Private Sub Workbook_BeforeClose() MsgBox "This document is now CLOSING." End Sub And also: Workbook_Close Auto_Close, none of which appear to work. Any ideas? Thanks Ian M |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Works fine for me
With new WorkBook and Worksheet events you need to do a Save and Close for the first time before code is activated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto-Close | Excel Discussion (Misc queries) | |||
Auto save and close | Excel Worksheet Functions | |||
Auto close .csv files | Excel Discussion (Misc queries) | |||
Auto close userform | Excel Discussion (Misc queries) | |||
Auto Close | Excel Programming |