Exporting worksheets to separate workbooks as duplicates vb

Hi Guys,
I am using a code to create duplicate workbooks for each page of my master workbook, and send them into a folder. Is there any way I can alter this code to just pick specific worksheets to export to individual workbooks?

Please Login or Register  to view this content.

Thanks all!

Vicho, that's great. This works well. On top of this:
Is there any way I can just list the tabs in the code that I want to export, without a msgbox prompt?

Please Login or Register  to view this content.

Thanks again,
jp