Copying Certain Sheets in WB to a New WB

[honger]

Hello,

I currently have a userform which creates a new WB by copying the entire active WB. Is there a way to just copy certain Sheets from the active Wb according to a value chosen from a Listbox?

For example, if I choose Template 1, it would only copy sheets 1,2,3 from active workbook. If i choose template 2, it would only copy sheets 1,4,5 from active workbook.

This is the current code i have, where and what code do i have to put in order to achive what i want? thank you all in advance

Please Login or Register  to view this content.

[natefarm]

Please Login or Register  to view this content.