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



"Piotr Lipski" wrote in
message ...
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.

--
PL