Re - GGVT Excel Copy of a WorkSheet Takes Mighty Long Time

An Excel WorkSheet1 contains two event-handlers namely,
1. SelectionChange
2. BeforeRightClick

When WorkSheet1 is copied en masse (selected by clicking the
top-left-corner thereof) to another WorkSheet2, it takes a really
mighty long time to complete the task.

The question is, what is holding up the copy-and-paste operations ?

Is there a way to circumvent the lengthy duration of the process ?

As a comparison, a regular WorkSheet3 (reasonable sized but minus the
event-handlers) could be copied (sheet-to-sheet) rather rapidly.
Please share your comment on the above delineation.

Regards.

Comment out the event handlers and try doing the copy. does it make a
difference?

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Re - GGVT Excel Copy of a WorkSheet Takes Mighty Long Time

An Excel WorkSheet1 contains two event-handlers namely,
1. SelectionChange
2. BeforeRightClick

When WorkSheet1 is copied en masse (selected by clicking the
top-left-corner thereof) to another WorkSheet2, it takes a really
mighty long time to complete the task.

The question is, what is holding up the copy-and-paste operations ?

Is there a way to circumvent the lengthy duration of the process ?

As a comparison, a regular WorkSheet3 (reasonable sized but minus the
event-handlers) could be copied (sheet-to-sheet) rather rapidly.
Please share your comment on the above delineation.

Regards.