Time to call in the experts on this one. I need to copy a worksheet that includes macro buttons to many others in the same workbook. Any ideas? Thanks!!
Time to call in the experts on this one. I need to copy a worksheet that includes macro buttons to many others in the same workbook. Any ideas? Thanks!!
Last edited by The Skipper; 02-22-2012 at 08:59 PM.
Hi Skipper,
If you want to copy the worksheet with macro buttons, just click on the worksheet and drag it to right and then you can always rename it. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
That works but only for one worksheet at a time. Is there a way to copy it across many worksheets? Thanks.
mmmmmmm I thought it worked to copy one worksheet at a time, but all it did was change the position of the original worksheet.
Hi Skipper,
One you have that another copy sheet created, then you can select both the sheet and right click - > copy and then you'll have 4 sheet and so on....
Using this approach, this will be multiplied and can be copied.
And then you can rename them as per your choice.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi Skipper,
Reply to your post#4,
Either you need to ctrl+click and drag OR right click -> copy -> create copy checkbox checked.
Regards,
DILIPandey
<click on below 'star' if this helps>
I can copy to a new worksheet one at a time using "copy/move" but dragging while holding the CTRL key and the left mouse key only moves the original worksheet.
Hi Skipper,
If you have selected many sheets using ctrl key, right click and Move or Copy, create a copy and then you'll have the copies created as dragging may not help here.
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks