Thread: Need an easy way to remove all commandbars
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Need an easy way to remove all commandbars
Hi Karoo

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Karoo News" wrote in message ...

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




Reply With QuoteReply With Quote