Copying form control button between tabs

[AlexCS]

Hi everyone,

How does one have to reference a form control button to be able to copy it from one tab to another in the same worksheet?

Copying the whole tab does not solve the problem sadly. Also, when trying to use the code resulting from the macro recorder, I am being told my button cannot be found. The button is called Send e-mail

The syntax of my copy-paste job (the button is in the range mentioned)

Sheets("Template by del").Select
ActiveSheet.Range("A1:Z500").Copy
Sheets("Sheet" & k).Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False

What the macro recorder says

Sheets("Template by del").Select
ActiveSheet.Shapes("Button 1").Select
Selection.Copy
Sheets("Sheet" & k).Select
Range("J1").Select
ActiveSheet.Buttons.Add(960.75, 15.75, 108, 21.75).Select
ActiveSheet.Paste

 

[obiron]

Each button on the tabbed form will be it's own control, therefore you cannot just 'copy' it. You will need to create separate buttons. If you want the buttons to all do the same thing then put the processing code in a sub procedure in a module and on each commandbutton___click event simply call the module sub procedure

 

[AlexCS]

Thanks for the explanation obiron