ExcelBanter - copy sheets to another file

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - copy sheets to another file (https://www.excelbanter.com/excel-programming/279957-copy-sheets-another-file.html)

Gareth[_3_]

copy sheets to another file

I have a macro which copies several sheets to another file and then deletes
all the sheet code.

I now find that there are 2 extra sheets to be copied but the sheet code is
required in them.

How can I get around this?

Don Guillett[_4_]

copy sheets to another file

Gareth, As usual you should always post your coding efforts.

"Gareth" wrote in message
...
I have a macro which copies several sheets to another file and then
deletes
all the sheet code.

I now find that there are 2 extra sheets to be copied but the sheet code
is
required in them.

How can I get around this?

Tom Ogilvy

copy sheets to another file

Deleting the sheet code is an overt act.
Test for the sheetname and don't delete the code in those sheets?

--
Regards,
Tom Ogilvy

Gareth wrote in message
...
I have a macro which copies several sheets to another file and then
deletes
all the sheet code.

I now find that there are 2 extra sheets to be copied but the sheet code
is
required in them.

How can I get around this?

All times are GMT +1. The time now is 08:09 PM.