Deleting Command Bars on close of a workbook

[Guest]

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.

 

[Tom Ogilvy]

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