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?

I think you will need to describe your setup and show us your code so we can
try to duplicate the problem. If these items are too big to do this, then
perhaps you can post your workbook on one of those free websites set up to
do that and then provide us with a link to it.

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
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?

Do not know how to load the data on the web so I will try to explain better...

I have a large macro where I move cell values, do some sorting, validate
some data and even jumpo from one sheeet to another... so in order not to see
all the sorting and the moving from one sheet to another I start my macro with


Application.ScreenUpdating = False
all the macro activities
Application.ScreenUpdating = True

On my main worksheet I have some rectangles where I do assign my macros....
When I run the macro teh screen and data does not move until it finish but
the rentacgles seems to blink several times (in a couple of seconds) and I do
not like ti... I would like somehow have the rentangles frozeen and do not
blink.

Looks like Application.ScreenUpdating will not apply to rectangles.
Hope this helps


"Rick Rothstein" wrote:

I think you will need to describe your setup and show us your code so we can
try to duplicate the problem. If these items are too big to do this, then
perhaps you can post your workbook on one of those free websites set up to
do that and then provide us with a link to it.

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
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?

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?

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?

I still think it would be useful for us to be able to see your code. Maybe
use a site like this one...

http://www.mediafire.com/

I've never used this site and I am not endorsing it... it was the first one
I Googled which had a green checkmark on it (my Norton 360 software's
SiteSafe feature puts checkmarks on searched for sites green checkmarks are
safe, gray question marks were never tested, red x is totally unsafe).

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
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?

Couple other upload sites.

http://www.freefilehosting.net/
http://savefile.com/

After uploading, post the URL.


Gord

On Sat, 19 Sep 2009 13:26:00 -0400, "Rick Rothstein"
wrote:

I still think it would be useful for us to be able to see your code. Maybe
use a site like this one...

http://www.mediafire.com/

I've never used this site and I am not endorsing it... it was the first one
I Googled which had a green checkmark on it (my Norton 360 software's
SiteSafe feature puts checkmarks on searched for sites green checkmarks are
safe, gray question marks were never tested, red x is totally unsafe).

Never done this before... hop eit works.. i believe you can see it on

http://www.mediafire.com/myfiles.php

The directory is call Alberto 90919
Only one file posted

"Gord Dibben" wrote:

Couple other upload sites.

http://www.freefilehosting.net/
http://savefile.com/

After uploading, post the URL.


Gord

On Sat, 19 Sep 2009 13:26:00 -0400, "Rick Rothstein"
wrote:

I still think it would be useful for us to be able to see your code. Maybe
use a site like this one...

http://www.mediafire.com/

I've never used this site and I am not endorsing it... it was the first one
I Googled which had a green checkmark on it (my Norton 360 software's
SiteSafe feature puts checkmarks on searched for sites green checkmarks are
safe, gray question marks were never tested, red x is totally unsafe).

Never done this before... hop eit works.. i believe you can see it on

http://www.mediafire.com/myfiles.php

The directory is call Alberto 90919
Only one file posted

"Rick Rothstein" wrote:

I still think it would be useful for us to be able to see your code. Maybe
use a site like this one...

http://www.mediafire.com/

I've never used this site and I am not endorsing it... it was the first one
I Googled which had a green checkmark on it (my Norton 360 software's
SiteSafe feature puts checkmarks on searched for sites green checkmarks are
safe, gray question marks were never tested, red x is totally unsafe).

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
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?

I don't think you posted the correct link... the one you posted looks like
it is trying to take us to your account.

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
Never done this before... hop eit works.. i believe you can see it on

http://www.mediafire.com/myfiles.php

The directory is call Alberto 90919
Only one file posted

"Rick Rothstein" wrote:

I still think it would be useful for us to be able to see your code.
Maybe
use a site like this one...

http://www.mediafire.com/

I've never used this site and I am not endorsing it... it was the first
one
I Googled which had a green checkmark on it (my Norton 360 software's
SiteSafe feature puts checkmarks on searched for sites green checkmarks
are
safe, gray question marks were never tested, red x is totally unsafe).

--
Rick (MVP - Excel)


"Alberto Ast" wrote in message
...
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?