I am coping a few worksheets into a new workbook using the following code (which works fine)...
Sheets(Array("Data", "Lists", "Summary", "BarChart", "ErrorChart", "Datastream_Data")).Copy
The problem now is that these sheets use code from a VBA module in the orginal workbook. Is is possible...