Apache OpenOffice Community Forum

Posted: **Wed Dec 06, 2023 5:18 pm**

On sheet named 'Sheet1', I have a Push Button named 'Switch' with Label 'ON' and font colour green. After the button's action is executed I want to change it to 'OFF' and Red.
What is the best way to do that?

Posted: **Wed Dec 06, 2023 6:32 pm**

Here is a sample file with an embedded macro.

ButtonProperties.ods: (10.14 KiB) Downloaded 524 times

Modified sample: I just deleted two helper Print commands.

Posted: **Wed Dec 06, 2023 8:06 pm**

Thank you Zizi64 - a nice solution.

Apache OpenOffice Community Forum

[Solved] Change properties of Calc Push Button using macro

[Solved] Change properties of Calc Push Button using macro

Re: Change properties of Calc Push Button using macro

Re: Change properties of Calc Push Button using macro