how to activate a controlMso

[Ddadoo57]

Hello,



Can someone tell me how to activate a controlMso from VBA?

Here is what I have in my ribbon :
<control idMso="ReviewSendForReview" enabled="false" />

Thanks in advance !


Best regards,
David

[Peterson]

Try this:

Application.CommandBars.ExecuteMso ("ReviewSendForReview")

[Ddadoo57]

Thank you very much for your feedback!

Actually, it's not "execute" the Mso control that I need, it's put enabled="True" to the line of code in the xlm file of my ribbon

<control idMso="ReviewSendForReview" enabled="false" />

It's a locked button in my personal bar, it is locked at le loading, and i want to unlock it after a certain user action.

My tab bar is called "TC_Tab".

Best Regards,
David

[Peterson]

Sorry, I don't know how to do that. I can see the XML file for custom ribbons in the UI file here:

C:\Users\<username>\AppData\Local\Microsoft\Office \Word.officeUI

...and I can manipulate the boolean value there, but I don't know how to do it with VBA except to open/modify the .officeUI file externally, but it's already loaded when Word is open, so changing it has no effect. My guess is, to change it while Word is open, you'd need to programmatically remove the button, not change its visibility attribute, then add it back when Word is closed. Someone on this board will know how to do that.

[Ddadoo57]

That's okay! Anyway, thanks for your time!

Best Regards,
David

[Guessed]

Rather than including in the ribbon code the Enabled=True, you need to use the attribute getEnabled and include a callback macro to work out whether the button is enabled or not

See Confused over getEnabled for Ribbon

Note that when fiddling with code AFTER the ribbon has loaded, you may discover the updated code doesn't execute. Either reload the ribbon or close/reopen the document containing the ribbon to ensure the code is working.

[Ddadoo57]

Hello Guessed and thank you for your answer.

Great, I will try the callback on getEnabled. I hadn't thought about it!

Best REgards,
David