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

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

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