Window Event

N

Nigel

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
 
C

Chip Pearson

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
 
N

Nigel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

closing another file by code causes failure to run workbook activate event 2
auto_close give me additional information? 4
BeforeClose Event problem 2
Disable Minimize/Maximize button for Excel 2007 Application 3
Workbook Switching Strategy 7
Restoring Attached Toolbar 4
STOP close button on another workbook 6
Delete a worksheet before closing workbook 4

Top