| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
