View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karoo News Karoo News is offline
external usenet poster
 
Posts: 9
Default Need an easy way to remove all commandbars


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("&Custom ize...").Delete
Application.CutCopyMode = False
Call MyMenu

Many Thanks
Neil