can you please heep,
I'm using attached code for my workbook.
I have 3 issues.
1- instead of saving selected sheets to a new workbook, it is saving all sheets.
2- Sheet Com1 is saved but no sub-total group.
3- Excel stays open after I run the code.
Any help is appreciated.