What VB script is needed to, say, change the colour of a control button say
from gray to red when it is clicked.

I've tried using the scripts given in:

http://www.mrexcel.com/archive/Controls/5034.html

but nothing is happening when the button is clicked - if I format it as grey
and click it, then it stays gray, if I format it as red and click it, it
stays red. I would like it to change to red when clicked and remain gray
when not clicked - it must be possible!

many thanks