shape (with macro assigned) flashes upon click

[grime]

I have a macro which activates when the user clicks on a shape. The
macro works perfectly, but the shape "flashes" upon the user click.

Any way to turn off this flashing/color change?

 

[Guest]

In the called macro you need to turn the screenupdating off and back on
something like this.

Sub MySub
On error goto Errorhandler
application.screenupdating = false
'Your Code

ErrorHandler:
application.screenupdating = true
end sub

Note: as with any application seeting you are best off to use an error
handler similar to the above example in case your code crashes, you want to
reset the application settings.