First create the macro in a standard module:

Sub yetanother()
Sheets("mysheet").Copy After:=Sheets(1)
End Sub

Then View Toolbars Forms and create the button and assign the macro to it.
--
Gary's Student
gsnu200708


"Maggie" wrote:

I am trying to do a macro with a button. I want to be able to click
the button to make another a duplicate of the same worksheet. Is
there a way to do that?