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