copy only selected worksheets

C

CC

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
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Move/Copy Worksheet with Macros 2
Macro to Copy Sheets to new workbook 18
excel 2010 + copy array 3
problems getting this macro to work 23
Copy same formula to all worksheets in a workbook 1
Copy all formats and objects 5
macro to copy workbook with several worheets 2

Top