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.
Bookmarks