screen update
Rectangles made from the drawing tool bar so I can assign my macros to. I put
a text to explain what they do and color it so they look nice.
I added about 10 rectangles and assign a macro to each one but each time I
click one to execute a macro all of the blink a little.
"Gord Dibben" wrote:
What do you mean by "rectangles"?
What type of rectangle and what purpose do they serve?
Gord Dibben MS Excel MVP
On Sat, 19 Sep 2009 08:56:10 -0700, Alberto Ast
wrote:
I have some macros but in order not to show what they so and just update
screen at the end by usaing
Application.ScreenUpdating = False
Application.ScreenUpdating = True
But there are some rectangles that still blinks while doing the macros...
what can I do so nothing moves until macro ends?
|