Calling MVPs and Microsoft Techs and Excel experts

D

Dale Fye

Ref the thread labeled "Custom commandbar (1 works, 1 doesn't)" has a
discussion of a problem I have encountered with a custom commandbar.

I've created my own File menu options, one of which is Print, which has
additional options under it. When I try to enable/disable controls on the
Print sub-menu the statement:

Application.CommandBars.FindControl(Tag:="ControlTag").Enabled = True

Has no effect on the button.

Additionally, when I try to use the msoButtonUp and msoButtonDown values to
change the state of a button control on that Print sub-menu, it changes the
state, but the new state value is not reflected by addition or removal of the
checkbox preceeding the button.

Both of the techniques mentioned above work properly on 1st level menus
(msoBarPopup), but not on second level menus (msoControlPopup). Is this a
design feature, or a bug?

Dale
 

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

Custom commandbar (1 works, 1 doesn't) 6
Can't get Control.State to work 15
Change CommandBarButton state not working 0
Adding custom menus to existing excel application 0
Problem setting the State of a custom Toolbar button 4
MenuItem Check Mark 1
Screen position of commandbar button in Excel 2007 ? 11
Drop Down Menu link to Pivot 0

Top