copy worksheet without including vba code

[cedtech23]

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

Please Login or Register  to view this content.

[Ingolf]

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

[Ron de Bruin]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>