Copy Sheets

poleary2000 · Apr 17th, 2002, 07:41 PM

I have a worksheet that has several ActiveX controls. What is the most expediant way to copy this sheet and place it before the sheet that is being copied? I have tried

ActiveSheet.Copy

It takes about 10 seconds to copy. Is there another way to copy the sheet that will be faster?

Any suggestions?

Eddie G. · Apr 17th, 2002, 07:53 PM

Sub Macro1()
Sheets("Sheet1").Copy Before:=Sheets(1)
End Sub

poleary2000 · Apr 17th, 2002, 07:58 PM

I'm sorry. I should have been more specific. The code I am currently using is:

ActiveSheet.Copy Before:=Sheets("Start")

This takes between 10 & 15 seconds to copy the sheet because it has about 15 ActiveX controls on it. Is there anyway to speed this process up?

poleary2000 · Apr 18th, 2002, 06:59 AM

I can't get any other method to work other than what I have already tried. Any ideas?

poleary2000 · Apr 18th, 2002, 09:20 AM

I really need some help with this. I have looked at various website regarding making code run faster but can't find anything on this specific topic.

fdrl · Apr 18th, 2002, 09:58 AM

This might or might not help :-

http://support.microsoft.com/default...;en-us;Q292298

poleary2000 · Apr 18th, 2002, 01:23 PM

No...sorry doesn't really help.

Guess this is a lost cause??

Apr 17th, 2002, 07:41 PM	#1
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	I have a worksheet that has several ActiveX controls. What is the most expediant way to copy this sheet and place it before the sheet that is being copied? I have tried ActiveSheet.Copy It takes about 10 seconds to copy. Is there another way to copy the sheet that will be faster? Any suggestions? __________________ Thanks in advance, Patrick

Apr 17th, 2002, 07:58 PM	#3
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	I'm sorry. I should have been more specific. The code I am currently using is: ActiveSheet.Copy Before:=Sheets("Start") This takes between 10 & 15 seconds to copy the sheet because it has about 15 ActiveX controls on it. Is there anyway to speed this process up? __________________ Thanks in advance, Patrick

Apr 18th, 2002, 06:59 AM	#4
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	I can't get any other method to work other than what I have already tried. Any ideas? __________________ Thanks in advance, Patrick

Apr 18th, 2002, 09:20 AM	#5
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	I really need some help with this. I have looked at various website regarding making code run faster but can't find anything on this specific topic. __________________ Thanks in advance, Patrick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 07:53 PM	#2
Eddie G. Board Regular Join Date: Feb 2002 Location: OKC Posts: 98	Sub Macro1() Sheets("Sheet1").Copy Before:=Sheets(1) End Sub

Apr 18th, 2002, 09:58 AM	#6
fdrl Join Date: Apr 2002 Posts: 12	This might or might not help :- http://support.microsoft.com/default...;en-us;Q292298

Apr 18th, 2002, 01:23 PM	#7
poleary2000 Board Regular Join Date: Apr 2002 Location: Pittsburgh, PA Posts: 317	No...sorry doesn't really help. Guess this is a lost cause??