This will take the worksheet code across, but not code in a standard code
module

Sheets("Sheet1").Copy


--

HTH

RP

"rpgun" wrote in message
...

Confused newbie question...

I have several tabs in a workbook. I want to copy only the "template"
tab to a new workbook and have the new workbook reflect the same
workbook attributes (code) as the old. Can I do this?

I really appreciate any help you could provide.

Thanks,
Bob


--
rpgun
------------------------------------------------------------------------
rpgun's Profile:
http://www.excelforum.com/member.php...o&userid=15426
View this thread: http://www.excelforum.com/showthread...hreadid=272227