Depends where you go after you activate Sheet3 and do your stuff.

If you go from Sheet4 over to Sheet3, do something then come back you
will never see Sheet3

Application.ScreenUpdating = False
Sheet3.Activate
For Each cell In ActiveSheet.Range("A1:A45")
cell.Interior.ColorIndex = 6
Next
Sheet4.Activate

But, there is rarely any reason to activate a sheet or select things.

The above can be written without any screenupdating=false or
activations

For Each cell In Sheet3.Range("A1:A45")
cell.Interior.ColorIndex = 6
Next

Show us your "code here"


Gord

On Thu, 15 Dec 2011 01:47:07 +0000, vom
wrote:


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.
Is there any way to stop this from happening?