MOVE or COPY tab in excel

[Sweedler]

Hello

When you right click on a tab in excel and select "MOVE OR COPY" there is a checkbox with the text "Create a Copy". That checkbox is always blank, is there any way to make that checkbox to be selected as a default setting.

Regards
Marcus

 

[Fluff]

Not that I'm aware of.

 

[Joe4]

For whatever it is you are trying to accomplish, it sounds like a good candidate to create some VBA code to do, and then you could assign the code to a button or keyboard shortcut.

 

[Sweedler]

I was afraid that there might not be a way around this one.

@Joe4 I think that there is not macro for this, at least that I would know of. As this is part of EXCEL's own programming, I do not know how to influence it.

 

[Joe4]

I think that there is not macro for this, at least that I would know of. As this is part of EXCEL's own programming, I do not know how to influence it.

I am not suggesting to try to create VBA code to influence that exact feature, what I am suggesting is creating VBA code to do what you ultimately trying to accomplish.

 

[Alex Blakenburg]

Try Ctrl+left mouse click on the Tab (you will see a little + symbol), then drag it to the another position on the sheet tab section (or almost anywhere in the sheet) and it will copy it.
If you have a second workbook open and visible you can do the same and drag it to the other workbook and it will create a copy there.

 

[Sweedler]

@Alex Blakenburg I am not seeing what you are explaining. But I want to move two tabs, copies, into a new worksheet.

 

[Alex Blakenburg]

The method I was thinking off is described in more detail under the heading "Copying a Sheet into a New Workbook" on Excel Campus here >

How to Quickly Move or Copy Sheets Between Workbooks in Excel - Excel Campus

Learn how to move an entire worksheet from one Excel workbook to another, or create a duplicate worksheet in another workbook with this quick tip.

www.excelcampus.com

To copy multiple sheets use Shift or Ctrl to select the sheets you wish to copy.

If by a New Workbook you mean a brand new workbook then hit Ctrl+N before you start to create that new workbook.

 

[Sweedler]

The method I was thinking off is described in more detail under the heading "Copying a Sheet into a New Workbook" on Excel Campus here >

How to Quickly Move or Copy Sheets Between Workbooks in Excel - Excel Campus

Learn how to move an entire worksheet from one Excel workbook to another, or create a duplicate worksheet in another workbook with this quick tip.

www.excelcampus.com

To copy multiple sheets use Shift or Ctrl to select the sheets you wish to copy.

If by a New Workbook you mean a brand new workbook then hit Ctrl+N before you start to create that new workbook.

Hello

Ok, I see what you were saying. I understand how to select multiple tabs. And, creating a brand new workbook is not what I am after.

What I want to do is select two tabs,
then right click and select "Move or Copy",
..
And here comes the rub. There is a checkbox in that menu, that you need to check in order to create a copy. If you do not, then the two tabs are moved into the new workbook (and that is not what we want). But I want the checkbox to be checked as a default.

 

[Alex Blakenburg]

I understand that ideally you don't want to tick the check box and as Fluff and Joe have indicated, you can't change that behaviour.
I was suggesting that simply holding down the control key and dragging the required sheets to the other workbook would be an alternative that might actually be quicker.