If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
captcure close application event
Hi,
I am new to VBA. Can anyone tell me how to capture Close Application (i.e. close all workbooks) event in Microsoft Excel using VBA? I know that, when i say close all, Microsoft Excel, fires close workbook for each workbook. But i need to know, if the user has clicked "close application", since i need to do data clean up on that event. thnx, suraj |
#2
|
|||
|
|||
captcure close application event
suraj,
There is no application level exit event. To see what events are available, visit Chip's page on events: http://www.cpearson.com/excel/Events.aspx "Another method to determine what events are available is to create an empty class module, and enter the following code: Dim WithEvents App As Application snip Then, select App in the left side dropdown at the top of the code window. All the events for the selected item in the left dropdown will be listed in the right dropdown." HTH, Bernie MS Excel MVP "suru" wrote in message ... Hi, I am new to VBA. Can anyone tell me how to capture Close Application (i.e. close all workbooks) event in Microsoft Excel using VBA? I know that, when i say close all, Microsoft Excel, fires close workbook for each workbook. But i need to know, if the user has clicked "close application", since i need to do data clean up on that event. thnx, suraj |
#3
|
|||
|
|||
captcure close application event
thnx for the inputs
|
Thread Tools | |
Display Modes | |
|
|