Remove transition between sheets
 

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

--
Message posted from http://www.ExcelForum.com

Remove transition between sheets
 

Hi Johnnyb,

Try:

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


---
Regards,
Norman



"Johnnyb " wrote in message
...
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.

Any help would be great,

Regards,

Johnnyb


---
Message posted from http://www.ExcelForum.com/

Remove transition between sheets
 

Hi Johnnyb,

Additionally, avoid selections which are rarely necessary.

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Johnnyb,

Try:

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


---
Regards,
Norman



"Johnnyb " wrote in message
...
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.

Any help would be great,

Regards,

Johnnyb


---
Message posted from http://www.ExcelForum.com/

Remove transition between sheets
 

On Fri, 6 Aug 2004 06:25:10 -0500, Johnnyb
wrote:

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