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?

[Jim Thomlinson]

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.
--
HTH...

Jim Thomlinson


"grime" wrote:

>
> 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?
>
>
> --
> grime
> ------------------------------------------------------------------------
> grime's Profile: http://www.excelforum.com/member.php...o&userid=19227
> View this thread: http://www.excelforum.com/showthread...hreadid=507653
>
>