Macro Help

M

Maggie

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?
 
G

Gary''s Student

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.
 
M

Maggie

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





- Show quoted text -
Click to expand...

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