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?

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?

On Feb 26, 12:08 pm, Gary''s Student
wrote:
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?- Hide quoted text -

- Show quoted text -

I tried that and it did not work. I also need to have the same format
brought over to each copy.