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

Macro to Copy Sheets to new workbook 18
How to insert new worksheet based on # of rows in a data sourch 2
problems getting this macro to work 8
Copying Portions of Data 0
Need Help with a VBA subroutine 0
Setting language of a selected text in Office apps. 0
Space at end of multi page list to accommodate new entries 1
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top