Need an easy way to remove all commandbars

[Karoo News]

Hi I currently use the follwing code to remove commandbars but would like a
simpler code to remove all. Also the first line of this code does not work
in office 95 is there a reason why? Idealy I need to Disable Customizing of
toolbars

'Application.CommandBars.DisableCustomize = True
Application.CommandBars("Toolbar List").Enabled = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Control Toolbox").Visible = False
Application.DisplayFormulaBar = False
Application.CommandBars("Tools").Controls("&Customize...").Delete
Application.CutCopyMode = False
Call MyMenu

Many Thanks
Neil

 

[Ron de Bruin]

Hi Karoo

See this page
http://www.rondebruin.com/menuid.htm

 

[Bob Phillips]

Commandbars don' work in Office 95 at all do they?

Anyway, this disab les them all, including c ontext menus

Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = False
Next oCB

 

[Tom Ogilvy]

Commandbars were not introduced in Excel until Office 97.