Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I want to able to change Sheet Object(a chart) Alternate state on the fly by pressing a button.
Is there a macros function to do that?
My backup plan is to make 2 charts with different states and use conditional show. But the macros would be better.
In that case use 'Set State Name' under Layout action type (trigger)
Having a trigger, I would always try to avoid a macro. See the attachment
Hope this helps.
I think you didn't understand. I need to change state of a whole chart.
In that case use 'Set State Name' under Layout action type (trigger)
That worked greatly!
Ty!