Remove transition between sheets

[Johnnyb]

I am using a button to copy data from one sheet to another. The cod
works fine but i can see the transitions being made from one sheet t
the next as it copies and pastes the data.
Does anyone know a way of hiding those transitions.

Any help would be great,

Regards,

Johnny

 

[Norman Jones]

Hi Johnnyb,

Try:

Application.DisplayAlerts = False
'Your code
Application.DisplayAlerts = True

 

[Norman Jones]

Hi Johnnyb,

Additionally, avoid selections which are rarely necessary.

---
Regards,
Norman

Hi Johnnyb,

Try:

Application.DisplayAlerts = False
'Your code
Application.DisplayAlerts = True

 

[jmac]

I am using a button to copy data from one sheet to another. The code
works fine but i can see the transitions being made from one sheet to
the next as it copies and pastes the data.
Does anyone know a way of hiding those transitions.

At the beginning of the sub containing the cut and paste code add the
following line:

Application.ScreenUpdating = False

Then, after that section of code, or just before the end of the sub
add the following line to restore screen updating:

Application.ScreenUpdating = True

This is a good snippet to add to any subroutine that would otherwise
show a lot of screen activity, which is visually annoying, and slows
down code execution.

jmac

Outside of a dog, a book is man's best friend.
Inside of a dog, it's too dark to read.
Mark Twain