Screen Updating/Flickering
 

Hi all,
I have a macro that is called from another that includes the following
2 lines at the start

Application.ScreenUpdating = False
Sheet3.Activate
code here

Everytime this runs the screen jumps from another worksheet to Sheet3
when it reaches line Sheet3.Activate
Is there any way to stop this from happening?

Thanks,
edul

Screen Updating/Flickering
 

"vom" wrote in message
...

Hi all,
I have a macro that is called from another that includes the following
2 lines at the start

Application.ScreenUpdating = False
Sheet3.Activate
code here

Everytime this runs the screen jumps from another worksheet to Sheet3
when it reaches line Sheet3.Activate
Is there any way to stop this from happening?

Thanks,
edul

Why post a question if you don't check it for solutions ??? Did you bother
to check the replies from your exact same post two days ago ?

Screen Updating/Flickering
 

On Fri, 16 Dec 2011 21:19:20 -0600, "MerseyBeat"
wrote:

"vom" wrote in message
.. .

Hi all,
I have a macro that is called from another that includes the following
2 lines at the start

Application.ScreenUpdating = False
Sheet3.Activate
code here

Everytime this runs the screen jumps from another worksheet to Sheet3
when it reaches line Sheet3.Activate
Is there any way to stop this from happening?

Thanks,
edul

Why post a question if you don't check it for solutions ??? Did you bother
to check the replies from your exact same post two days ago ?

Hi MerseyBeat

Apologies for that
For whatever reason my newsgroup reader does not show that post.

I knew I'd sent it, but cannot see it on here.
Would you be able to paste the reply in please.

Screen Updating/Flickering
 

Have a look here for a couple of replies.

http://tinyurl.com/c5s6kzf



Gord

On Sat, 17 Dec 2011 03:57:05 +0000, vom
wrote:

On Fri, 16 Dec 2011 21:19:20 -0600, "MerseyBeat"
wrote:

"vom" wrote in message
. ..

Hi all,
I have a macro that is called from another that includes the following
2 lines at the start

Application.ScreenUpdating = False
Sheet3.Activate
code here

Everytime this runs the screen jumps from another worksheet to Sheet3
when it reaches line Sheet3.Activate
Is there any way to stop this from happening?

Thanks,
edul

Why post a question if you don't check it for solutions ??? Did you bother
to check the replies from your exact same post two days ago ?

Hi MerseyBeat

Apologies for that
For whatever reason my newsgroup reader does not show that post.

I knew I'd sent it, but cannot see it on here.
Would you be able to paste the reply in please.

Screen Updating/Flickering
 

Thanks Gord
Am trying to sort my newsgroups out. Apologies again for double post.

On Fri, 16 Dec 2011 20:32:47 -0800, Gord Dibben
wrote:

Have a look here for a couple of replies.

http://tinyurl.com/c5s6kzf



Gord

On Sat, 17 Dec 2011 03:57:05 +0000, vom
wrote:

On Fri, 16 Dec 2011 21:19:20 -0600, "MerseyBeat"
wrote:

"vom" wrote in message
...

Hi all,
I have a macro that is called from another that includes the following
2 lines at the start

Application.ScreenUpdating = False
Sheet3.Activate
code here

Everytime this runs the screen jumps from another worksheet to Sheet3
when it reaches line Sheet3.Activate
Is there any way to stop this from happening?

Thanks,
edul

Why post a question if you don't check it for solutions ??? Did you bother
to check the replies from your exact same post two days ago ?

Hi MerseyBeat

Apologies for that
For whatever reason my newsgroup reader does not show that post.

I knew I'd sent it, but cannot see it on here.
Would you be able to paste the reply in please.