Use a CommandButton not a form button.
They copy with the code too.

--
Regards

Corey
"Nigel" wrote in message
ps.com...
i need to have a button at the beginning of each row, that copies the
row that the button is on to the next row below it.....

but when i copy a row to the next line, it doesnt copy the button. it
will copy it if im in design mode, but this worksheet is for other
users and it will be protected and not allowed to go into design mode.
can this be done?

(on a sidenote....is it possible to snap a button into a cell, making
the entire cell a button?)