copy only selected worksheets
 

can anyone help me on this ? many thanks

I have a workbook with many worksheets and some times I need copy some of
them to a new workbook .
what I need is a macro to copy the wks but first show me all the existents
sheets and request my choice with a check box 's

copy only selected worksheets
 

Similar functionality is already there in Excel 2003
Here is how you do it;
1. CTRL-Click on the sheets you want to copy
2. Right-Click on any of the selected sheet
3. Choose 'Move or Copy'
3. Check the box 'Create a copy'
4. Choose destination in the 'To book' dropdown

"CC" wrote:

can anyone help me on this ? many thanks

I have a workbook with many worksheets and some times I need copy some of
them to a new workbook .
what I need is a macro to copy the wks but first show me all the existents
sheets and request my choice with a check box 's