Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application Close Event
Hi,
I can't find such an event (Office 2003). Is it possible with VBA to detect that Excel is going to be closed? My goal: I want to prevent a workbook from being closed by the user as long as Excel is running. This is no problem with this eventhandler: Sub Workbook_BeforeClose(Cancel As Boolean) Cancel = True End Sub But in this way the workbook never is closed, even when Excel should close... Thanks, Robert. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
captcure close application event | Excel Worksheet Functions | |||
Before Close Event Hide all Worksheets then Close Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
How to Close an application? | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |