how do I copy worksheets between workbooks without the macros?
 

I'm using Excel 2003 and have a function that exports worksheet tabs from one
workbook to another using the copy method. Turns out that it copies
EVERYTHING - vba code, formatting, the whole nine yards. Since I want to
keep the formatting (for display and print), is there a way I can block the
vba code from copying so that when my users open the new workbook, they don't
get an error message because the vba code couldn't find a worksheet that I
didn't (and don't want to) copy?

Copy code:
curBook.Sheets(Array(tabname)).Copy befo=newBook.Worksheets(1)