Change SheetObject Alternate State via Macro

[#1]

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.

[tresesco]

Having a trigger, I would always try to avoid a macro. See the attachment

Hope this helps.

[#3]

I think you didn't understand. I need to change state of a whole chart.

[tresesco · Accepted solution]

In that case use 'Set State Name' under Layout action type (trigger)

[#5]

That worked greatly!

Ty!