Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code copy
hi,
i have the following: Sheets("tester").Copy after:=Sheets("tr") the "tester" sheet contains code that i would not like to be copied when the sheet is copied. what can i add to prevent the code from being copied when the sheet is copied? thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code copy
The code is embeded in the sheet so if you copy the sheet then you copy the
code. The easiest way around this is to just create a new sheet and then copy the cells from tester to the new sheet. Something like this... Sub CopyTester() Dim wks As Worksheet Set wks = Worksheets.Add(After:=Sheets("tr")) Sheets("tester").Cells.Copy Destination:=wks.Range("A1") End Sub -- HTH... Jim Thomlinson "geebee" wrote: hi, i have the following: Sheets("tester").Copy after:=Sheets("tr") the "tester" sheet contains code that i would not like to be copied when the sheet is copied. what can i add to prevent the code from being copied when the sheet is copied? thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
code copy
hi,
thanks... but the only problem with this code is that it does not handle/copy any radio buttons that are in the sheet to be copied. how can i copy these radio buttons? thanks in advance, geebee "Jim Thomlinson" wrote: The code is embeded in the sheet so if you copy the sheet then you copy the code. The easiest way around this is to just create a new sheet and then copy the cells from tester to the new sheet. Something like this... Sub CopyTester() Dim wks As Worksheet Set wks = Worksheets.Add(After:=Sheets("tr")) Sheets("tester").Cells.Copy Destination:=wks.Range("A1") End Sub -- HTH... Jim Thomlinson "geebee" wrote: hi, i have the following: Sheets("tester").Copy after:=Sheets("tr") the "tester" sheet contains code that i would not like to be copied when the sheet is copied. what can i add to prevent the code from being copied when the sheet is copied? thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy code | New Users to Excel | |||
Got the Copy/Cut Code But what is the Paste Code | Excel Programming | |||
Help with COPY code | Excel Discussion (Misc queries) | |||
Copy Code | Excel Programming | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming |