View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default disable custom toolbar

From VB, run this:

CommandBars("Worksheet Menu Bar").Controls("Choice").Enabled = False

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"choice" wrote in message
...
i have a custom menu toolbar (on the same toolbar as file,edit,etc)
the custom toolbar is named Choice it has about 5 submenus
is there a way to disable the toolbar Choice

thanks in advance