Hi,

I'm looking for a macro which list the total sheets in an active workbook and provide an option to select multiple worksheets at once and then save them as different workbooks.

I tried searching for it but all efforts are in Vain.

Can someone help on this.

Thanks in Advance.

Regards