Thread: screen update
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alberto Ast[_2_] Alberto Ast[_2_] is offline
external usenet poster
 
Posts: 181
Default 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?