| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Window Event
Hi All
I have an application that on opening stores the users ToolBar settings, and restores them using the workbook before close event. All is OK if the user exits using the File-Close or the Workbook window X button. However if they close the Excel Application then the tool bars are not restored. How can I detect that Excel is closing and so force my toolbar restore routing to run? TIA -- Cheers Nigel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window Event
The Workbook_BeforeClose will be triggered for each open workbook
when the Application is closed. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nigel" wrote in message ... Hi All I have an application that on opening stores the users ToolBar settings, and restores them using the workbook before close event. All is OK if the user exits using the File-Close or the Workbook window X button. However if they close the Excel Application then the tool bars are not restored. How can I detect that Excel is closing and so force my toolbar restore routing to run? TIA -- Cheers Nigel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Window Event
Chip,
I did discover this, my problem was in another area which I have since fixed. Many thanks ps Your site on Excel Events gave me some more insight. -- Cheers Nigel "Chip Pearson" wrote in message ... The Workbook_BeforeClose will be triggered for each open workbook when the Application is closed. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nigel" wrote in message ... Hi All I have an application that on opening stores the users ToolBar settings, and restores them using the workbook before close event. All is OK if the user exits using the File-Close or the Workbook window X button. However if they close the Excel Application then the tool bars are not restored. How can I detect that Excel is closing and so force my toolbar restore routing to run? TIA -- Cheers Nigel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| View cell contents as a pop-up window (similar to comments window) | Excel Worksheet Functions | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| event in worksheet switches to VB code window | Excel Programming | |||
| Excel main window close event | Excel Programming | |||
| "window scroll" event | Excel Programming | |||
Linear Mode
