Workbook Close application: 'Cancel' problem???

I have a toolbar application that is created using vba, I am using the code below to close the toolbar when the workbook closes.

Please Login or Register  to view this content.

However if the user decides not to close the workbook and clicks cancel then the toolbar is lost.
To retreive the toolbar either the macro to open the workbook can be run or the file closed then re-opened. Neither of these are desired.

How do keep the toolbar if the user chooses cancel when attempting to close the workbook.

thanks
Arfan

*EDIT* Just solved it, but if there is a better way then ur reponse is appreciated.

Please Login or Register  to view this content.

It's always best to create the ToolBar within your code. If you do a Forum search you will find examples like

http://www.excelforum.com/excel-prog...an-add-in.html