Deleting Command Bars on close of a workbook
 

I have found code to delete the custon command bars, I put it in a macro and
it will delete the command bar I list.

I need to find out how to delete a command bar from the computer, when I
close an Excel workbook. I have several custon command bars and the list gets
to long.

Deleting Command Bars on close of a workbook
 

Put the delete code in the the BeforeClose event

See Chip Pearson's page on events if you are not familiar:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Stan Bottorff" <Stan wrote in message
...
I have found code to delete the custon command bars, I put it in a macro
and
it will delete the command bar I list.

I need to find out how to delete a command bar from the computer, when I
close an Excel workbook. I have several custon command bars and the list
gets
to long.