Copy entire worksheet to another including macro buttons

**The Skipper** · 02-15-2012, 10:52 PM

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!!

**dilipandey** · 02-15-2012, 11:08 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>

**The Skipper** · 02-15-2012, 11:15 PM

That works but only for one worksheet at a time. Is there a way to copy it across many worksheets? Thanks.

**The Skipper** · 02-15-2012, 11:21 PM

mmmmmmm I thought it worked to copy one worksheet at a time, but all it did was change the position of the original worksheet.

**dilipandey** · 02-15-2012, 11:22 PM

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>

**dilipandey** · 02-15-2012, 11:23 PM

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>

**The Skipper** · 02-15-2012, 11:34 PM

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.

**dilipandey** · 02-16-2012, 12:12 AM

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>