Thread: how to Delete Format Menu Toolbar From Excel
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 how to Delete Format Menu Toolbar From Excel
Hi vicky

See
http://www.rondebruin.nl/menuid.htm

You can use this for the Format menu in the menu bar for example
Application.CommandBars("Worksheet Menu Bar").FindControl(ID:=30006).Enabled = False



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"vicky" wrote in message ...
I need a code thru which i need to remove Format Toolbar . i.e the
user shuld not be able to have access to Format toolbar ...
Reply With QuoteReply With Quote