shape (with macro assigned) flashes upon click

  • Thread starter Thread starter grime
  • Start date Start date
G

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?
 
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.
 
Back
Top