Change Code to save in selected sheets with inputboks

[abjac]

HI I have below code which works fine to save in this example sheet2 in new workbook.
What i really would like is a code which with and inputboks will ask which sheets i want to save in the saved new workbook.
Example if i want to save Sheet2 and Sheet3 and Sheet11. i can write in the inputboks 1,2,11
I have 11 Sheets from 2 to 11, where it would be great to choose which i want to save in new workbook.
Here below is the code i use for save one specified sheet. And if some can change it to work with upper criteria,
it would really be great.
I have attached a test workbook to try with below.
Hope some have the time to help.
Sincerely
Abjac

Below my code to save one specified sheet in new workbook.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Administrative note

Still using XL2003 as indicated in your profile?
If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
Thanks

[abjac]

HI I just updated in i use excel 2010 and at work excel 2013

[abjac]

HI I still play with this and below code can specify the selected sheets but i need a input box where i can specify which sheet i need safe in new workbook.
This is the code where i can specify the sheets here its from sheet2 to sheet11 which i need. I can change the code so it safe the sheets i want. But not with a input box between Sheet2 and Sheet11 which is what i need. I was thinking to example in a input box put 2 as sheet2, 5 as sheet5 example so i type 2,5 and it will safe sheet2 and sheet5 in a new workbook. Have a look please
Sincerely Abjac

This is the code where i can specify the sheets but without a input box to select.

Please Login or Register  to view this content.