| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy worksheet without including vba code
I wish to copy a worksheet using vba but not include the VBA code an userform with the copy. IS this possible if so how? Thanks Code ------------------- ActiveWorkbook.Sheets(1).Copy ------------------- -- cedtech2 ----------------------------------------------------------------------- cedtech23's Profile: http://www.excelforum.com/member.php...fo&userid=3102 View this thread: http://www.excelforum.com/showthread.php?threadid=56337 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy worksheet without including vba code
Hi,
copy a range instead. ActiveWorkbook.Sheets(1).Cells.Copy Workbooks("abc.xls").Worksheets.Add ActiveSheet.Cells.PasteSpecial Paste:=xlPasteAll Regards, Ingolf cedtech23 schrieb: I wish to copy a worksheet using vba but not include the VBA code and userform with the copy. IS this possible if so how? Thanks Code: -------------------- ActiveWorkbook.Sheets(1).Copy -------------------- -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563379 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy worksheet without including vba code
Hi cedtech23
You can delete the VBA in the new workbook http://www.cpearson.com/excel/vbe.htm I always use my Mail add-in and send the worksheet without VBA to myself http://www.rondebruin.nl/mail/add-in.htm -- Regards Ron de Bruin http://www.rondebruin.nl "cedtech23" wrote in message ... I wish to copy a worksheet using vba but not include the VBA code and userform with the copy. IS this possible if so how? Thanks Code: -------------------- ActiveWorkbook.Sheets(1).Copy -------------------- -- cedtech23 ------------------------------------------------------------------------ cedtech23's Profile: http://www.excelforum.com/member.php...o&userid=31022 View this thread: http://www.excelforum.com/showthread...hreadid=563379 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Worksheet with Code | Excel Programming | |||
| How to copy a worksheet without its code ? | Excel Programming | |||
| Copy Worksheet without VB code attached? | Excel Programming | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
| Copy worksheet, code and all, into workbook? | Excel Programming | |||
![cedtech23[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
