Disabled Button On Ribbon

[glda19]

Hi

Can some told me what im dowing wrong?
I want to disabled button 2 from Group2 on the ribbon.

But when i click on the button Disable Button2 of group2 he enabled the button.
So i thought i make a new sub GetDisabledMarco.
But he always activade the macro GetEnabaledMacro
So my Xml code is

Please Login or Register  to view this content.

[Keebellah]

Very simple, if you check you vba code the macro doesn not exist, that's exactly what the message tells you
Check the vba module with the ribbon macros
Good-night!

[Dhanvey]

I do not see what you are trying to do, but as the code goes.

[code]
tag="Group1Button1" getEnabled="GetEnabledMacro"/>
<button id="G1B2" label="Caption 2" size="normal" onAction="Macro2" imageMso="AccountMenu"
tag="Group1Button2" getEnabled="GetEnabledMacro"/>
<button id="G1B3" label="Caption 3" size="normal" onAction="Macro3" imageMso="RegionLayoutMenu"
tag="Group1Button3" getEnabled="GetEnabledMacro"/>
</group>

<group id="MyCustomGroup2" label="Group2" tag="MyPersonalGroup2" >
<button id="G2B1" label="Caption 1" size="normal" onAction="Macro4" imageMso="DirectRepliesTo"
tag="Group2Button1" getEnabled="GetEnabledMacro"/>
<button id="G2B2" label="Caption 2" size="normal" onAction="Macro5" imageMso="AccountMenu"
tag="Group2Button2" getEnabled="GetDisabledMarco"/>
<!-- button id="G2B2" label="Caption 2" size="normal" onAction="Macro5" imageMso="AccountMenu"
tag="Group2Button2" getEnabled="GetEnabledMacro"/ -->


[code\]


button id G2B2 you have two. the second you have commented out has a viable macro call.

the first has "GetDisabledMarco" which does not exist.

[glda19]

I have now put the macro to it.
What im trying to do is to disable not alle the buttons but one button by tag.
And when i click eanbled all all the buttons must be enabled. now button2 off group 2 is disabled
By Clicking on disabled all buttons must be disabled and now button2 of group 2 is enabled.

How can i disable one button by tag that is what im trying to do.

[Keebellah]

May I ask you a question: do you have any idea how the ribbon tags work?
My guess is you read something you like and you copied it without any notion of how the ribbon works.
I suggest you read moer about it. I can advise you a a good site: https://www.macexcel.com/examples/ri.../contextmenus/
Ron stopped with Windows but the Ribbon Context part in the MAC is the same as in Windows
I have returned your file with extra info in the message box so you can see how the button is identified

[glda19]

No i don't now how ribbon tags work.
Why did you give me the following linkhttps://www.macexcel.com/examples/ri.../contextmenus/
I see that it is the explanation of the context menu by right click not about ribbon tags

Where do i find more info about ribbon tags.

[Keebellah]

Have you even tried to read the article? Try to understand?
What's the use if you do not even put an effort into understanding the basics of how the ribbon works?
You can look at your own file I attched back to you and open the ribbon editor

[glda19]

What have the context menu to make with tags

[ByteMarks]

Most disappointingly, Ron de Bruin has removed the Windows part of this (previously) excellent site.

However you can still access it on the archive, so this should be of some use to you.

https://web.archive.org/web/20180802.../s2/win012.htm

https://web.archive.org/web/20180802.../s2/win013.htm

[glda19]

I understand how you can use a tag to enbled the button.
But how can i do disable with a tag

[Keebellah]

Okay, let's say you do know how that works.
What do you want to achieve with these buttons?
You cannot enebale it if it's disabeld so can you explain what you really need?

[glda19]

I found a site of Ron de bruine ho explain how to program the ribbon. But he stopped the Windows excel site. He only have macexcel.com alive.
the file i post here is from Ron.
What I want is to see if it possible to disable one button on the ribbon by tag.
I store the example so I can see in the further how I must program the ribbon
Informatics is not my job. I have to hold sole values ore other thinks to control if they give the value correctly in the system that we use at work so I payed correctly

So I made a excel file where I hold the hours I no a certain job. And when there is a code in a Cell not is filled in then I generated a pdf that I mail to my boss

[glda19]

So now I'm leaving more about the ribbon programming and I want to see if it is possible to disable one button on the ribbon by tag

[Keebellah]

You can enable or disable a single button by checking a condition of a value in a cell of some other action.
I know his site is now for the macexel but if you look carefully you can see that the ribbon section is the same for both versions and ByteMarks posted two links and there you can actually download a file that does what you want, but you will have to at least understand how it all works, especially if you are going to do some more compliacted actions like mailing pdfs and so.

[glda19]

But is disable on the links by tag for one button I doet think so.
I want to now if it is possible by tag

[ByteMarks]

Here's a way you can do it using the tags.

Firstly you need to amend the callback in your xml so that GetEnabled for all the buttons refers to to GetEnabledMacro

In the VBA:
Declare the variable blnNot

Please Login or Register  to view this content.

Modify Sub GetEnabledMacro as follows:

Please Login or Register  to view this content.

Modify Sub RefreshRibbon as follows

Please Login or Register  to view this content.

Change Sub disableControlGroup2Button2 as follows

Please Login or Register  to view this content.

[Keebellah]

Looks good, I hope the OP understands the workings and takes the time to read more about the Ribbon

[ByteMarks]

Thanks.
The Ribbon is a bit of a learning curve if you are new to it.

Strongly recommend the rorya method to preserve the ribbon state too, referenced in the OP's code. I've added the links here as Ron's site is now expired.

https://www.mrexcel.com/board/thread...bon-ui.518629/

https://web.archive.org/web/20110528...ibbonstate.htm

[Dhanvey]

ok, took a while. but the attached is done without your tags.

I'm learning the marrage between XML and VBA. Its not clean (ie left the tag in xml & some other stuff) by you should get the concept.

[Keebellah]

Thanks.
The Ribbon is a bit of a learning curve if you are new to it.

I agree, it took me some time and a lot of Ron-tips reading time.