| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheets from several workbooks into one workbook | Links and Linking in Excel | |||
| Need macros for copy data into new workbooks | Excel Discussion (Misc queries) | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| cannot copy and paste worksheets or workbooks | Excel Discussion (Misc queries) | |||
| Protecting worksheets with Macros in Shared Workbooks | Excel Programming | |||
Threaded Mode
