vba excel RibbonX: Stepwise-access to controls within a single group or tab
Posted on 2013-05-30
This is a request for pointers toward solutions, so I can chase or ask about details.
I have a two stage process (StepA; StepB), controlled respectively by Macros A and B. I'd like to run the macros from the Fluent ribbon, off two controls ButtonA and ButtonB, in the same Tab.
It is simple to have button A visible then the tab is active.
But I'd like button B ONLY to work (be visible/be enabled) when Button A has been clicked.
I control the Tab and ButtonA off getVisible and tag values
I have sought a means to control ButtonB off its control.ID, but there is no controls collection through which I might set ButtonB as visible (and hopefully render ButtonA invisible when step B is initiated). I dont need to collect 'pressed' data from the buttons
Can RibbonX buttons be controlled like this, or is there another 'dynamic' approach?
I have tried using a toggle button to deliver 'two stage' control. But was concerned that he user-driven processes that occur in step A, might somehow lift the focus from the toggle button before stepA was complete. Perhaps I should return to it..
... but finally, I've heard that windows task panes provide more dynamic properties and can replace dynamic userForms, and utilise their vba. Is this so?
PS I dont use visual studio..