shape (with macro assigned) flashes upon click
 

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

shape (with macro assigned) flashes upon click
 

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