disable custom toolbar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
From VB, run this:

CommandBars("Worksheet Menu Bar").Controls("Choice").Enabled = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable the toolbar options button 4
Excel 2007 "Custom Toolbars Button" 2
Disable Print button & pulldown menu 2
Toolbars in Excel 2007 6
hide custom toolbar from Toolbar list 3
Creating custom toolbar 3
Mystery of the re-appearing custom toolbars 1
Most Recent Custom View 1

Back
Top