disable custom toolbar
 

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

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