Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Worksheet without VB code attached?
Is there anyway to copy a worksheet (with VB code) to a
new workbook without the VB code automatically getting attached to the copied sheet? My current code looks like this: Workbooks(WSNameC).Sheets(aa$).Copy after:=Workbooks (WSName1).Sheets(aa1$) Thanks for the advice. This forum is really helpful. Chris. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
code does not copy | Excel Discussion (Misc queries) | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
Copy Sheets minus Worksheet Change Event code & Macro Buttons | Excel Programming | |||
Copy worksheet, code and all, into workbook? | Excel Programming | |||
Is there a quick way to see which objects have code attached? | Excel Programming |