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

"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 ?

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.

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.

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.