Greying out Custom CommandBar items

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

Guest

Hi I have a custom Commandbar list I want to be able make items in the
commandbar greyed out when they can't be used, is this possible in VBA or is
it only done in C++ only can someone please help.
TIA
Frank
 
Frank,

In VBA, simply set the .Enabled property fo the items to False, then when
you want to re-enable them, set that property to True.

HTH,
Bernie
MS Excel MVP
 
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

CommandBars 1
Using Excel 2007 with Excel 2003 template 1
VB - Macro to list all controls in the Commandbar. 8
Custom Command Bars 1
Custom CommandBar visible dependent on active sheet 6
Userform with commandbar popup 2
Macro appears 5 times 3
enabling a custom menu at workbook open that is disabled 3

Back
Top