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