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

 

[Joe4]

As I was suggesting, if you don't want to do it manually, you could instead create some VBA code to do what you want automatically.
I.e. select the two tabs you want to do this to, and then run the VBA code that does what you want to those two tabs.