Hi Andy,

I dumped the macro into excel, and assigned it to the autoshape. When
clicked it changes color once, then reverts back to the original color
of the shape, eg, a yellow circle when clicked flashes blue, then
reverts to yellow, a green circle when clicked flashes pink, then
reverts back to green.

Any other suggestions?

Cheers, Tania