copy a command button to new worksheet

[elaine]

Hello,

Does anyone knows how to copy a command button to new worksheet?

I am a beginner and want to do things more effective, cos I have to
fill in different information in the same template but split across the
sheet.

eg.

I create a template in Sheet A and I have asign a macro (to copy the
whole sheet and insert a new sheet) to a command button.

Private Sub test()
Cells.Select
Selection.Copy
Sheets("Sheet1").Select
Sheets.Add
ActiveSheet.Paste
End Sub

When I click on that command button in sheet A, it will copy the whole
sheet A to a new sheet.

However the command button is not on the new sheet. (but still)

Is there a way to copy and paste the command button too, so that there
will always be a command button in the new sheet?

Thanks.

Elaine.

 

[Norman Jones]

Hi Elaine,

Try:

'=============>>
Public Sub Test()
Sheets("SheetA").Copy After:=Sheets(Sheets.Count)
End Sub
'<<=============

 

[Piotr Lipski]

On 22 Jun 2006 07:52:52 -0700, elaine wrote:

[..].

I create a template in Sheet A and I have asign a macro (to copy the
whole sheet and insert a new sheet) to a command button. [...]
Is there a way to copy and paste the command button too, so that there
will always be a command button in the new sheet?

Can't you just use the same button again?
Copying a button requires copying associated VBA code as well. This is
quite bad idea.

If you need some universal button (available all the time, on every sheet),
try to put it on a user form, not on a sheet.

 

[Norman Jones]

Hi Piotor,

Given Elaine's shown macro and the phrase "and I have asign a macro", I
assume that the button in question is a Forms button.

---
Regards,
Norman

On 22 Jun 2006 07:52:52 -0700, elaine wrote:

[..].

I create a template in Sheet A and I have asign a macro (to copy the
whole sheet and insert a new sheet) to a command button. [...]
Is there a way to copy and paste the command button too, so that there
will always be a command button in the new sheet?

Can't you just use the same button again?
Copying a button requires copying associated VBA code as well. This is
quite bad idea.

If you need some universal button (available all the time, on every
sheet),
try to put it on a user form, not on a sheet.