[Solved] Change cell color while sound is running

[N4LXP]

I have a macro that plays an mp3 file about 3 seconds long after a button is pushed. Someone else is listening to that mp3 file using a headset and the user can't hear it. At best, I would like to change the color of the button while the mp3 file is being played and if that is not possible I would like to change the color of the adjacent cell. Thanks so much for your help.

[Zizi64]

Of course you can change the color of a Form Control element (Button) by a macro.

You can change the color easily, when the button is clicked, and the macro is launched, by the first command of the macro. But it is harder to reset the button color, when the sound ends. There is not a built-in Event for this task.

[Zizi64]

Try to apply the function STYLE() by your macro with the usage of the timing option in the applied Cell Formula:

https://wiki.openoffice.org/wiki/Docume ... E_function

Apply the Cell Formula to the desired cell by your macro launched by the Button-click.

[Zizi64]

Here is a sample code embedded into the attached document:

FlashLight.ods

(10.36 KiB) Downloaded 165 times

[N4LXP]

Thanks for all the help. Using "Style" was an easy and elegant solution.