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

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