Hi,

I wonder if anyone can help me on this one.

I am trying to create a piece of VB code that from within an Excel spreadsheet creates a new work book and deletes the sheets that I select from the copy.

To explain more...

I have a workbook, with 4 sheets:
sheet A, sheet B, Sheet C, Sheet D

From this workbook I open a userform which states: "Reproduce workbook, new name__________" (i enter new name here e.g "book1" which becomes the new filename)

On the userform it lists: sheet A, sheet B, sheet c, sheet d with tickboxes next to them.

I click the tick box next to sheet A and sheet B. So it creates a workbook called "book1" with copies of sheet A and sheet B. Then it takes me back to the form so i can do another one.

I need all the VB code currently on sheet A and sheet B to transfer over to the new workbook.

Is this possible? thanks for any help you can offer me.

Nick