Deleting the toolbar or menubar removes it from the UI for the current
session but not from the workbook it is attached to or created by. You have
to remove it from there. If it's an attached toolbar (I know you said
menubar) there is no way to detach, as far as I know, in Excel 2007. You'd
have to do that in Excel 97-2003. If a macro is creating the menubar you'd
have to find the code and delete it.

--
Jim
"Troubled User" wrote in message
...
|I can delete custom menu items that I create in VB by using:
|
| Application.Commandbars(1).Controls("TheControl"). Delete
|
| However, in this file there is now a menubar (I don't know how it is being
| added as I am not doing it in code) called "Print All Sheets".
|
| I have tried to reference it by name as
| Application.CommandBars.Controls("Print All Sheets".Delete but get nothing
| (although this works perfect on the others that I add in VB").
|
| I can delete it by right clicking on it and selecting "Delete Custom
| Command", however it reloads itself (before my VB menu Add Ins are
accessed)
| when the file is reopened.
|
| Any ideas are much appreciated.
|
|
|