+ Reply to Thread
Results 1 to 7 of 7

Copy entire worksheet to another including macro buttons

  1. #1
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Copy entire worksheet to another including macro buttons

    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.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copy entire worksheet to another including macro buttons

    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
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Copy entire worksheet to another including macro buttons

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

  4. #4
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Copy entire worksheet to another including macro buttons

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

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copy entire worksheet to another including macro buttons

    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>

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copy entire worksheet to another including macro buttons

    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>

  7. #7
    Forum Contributor
    Join Date
    02-07-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    156

    Re: Copy entire worksheet to another including macro buttons

    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.

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copy entire worksheet to another including macro buttons

    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>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1