Easy way to add a button in excel?

[debralee]

I created a spreadsheet form in excel and want to add a click here button on the top of the spreadsheet that will automatically create a duplicate new blank field sheet for end users. I know its easier to just duplicate a sheet but I need an easy button for the end users.
Anyone anyone Bueler?

Please help

 

[My Aswer Is This]

You want to click a button and create a new empty worksheet is that correct?
If so create a button and put this script in the button.

Sub Add_New_Sheet()
Sheets.Add(after:=Sheets(Sheets.Count)).Name = "New"
End Sub

 

[My Aswer Is This]

I was not sure what this means:

"will automatically create a duplicate new blank field sheet"

You want to duplicate the active sheet but you want it blank.

Well a blank sheet is just a new sheet. So my script above give you a new sheet.

 

[jolivanes]

I think I see it slightly different. If that is so then we need to know which cells and/or ranges need clearing.

 

[debralee]

You want to click a button and create a new empty worksheet is that correct?
If so create a button and put this script in the button.

Sub Add_New_Sheet()
Sheets.Add(after:=Sheets(Sheets.Count)).Name = "New"
End Sub

Hi Thank you!
I'm sorry for not being more clear.

I created a master form that needs to be filled out.
I want end user to be able to fill the form in, then hit a button that will create a new copy of my Master form to fill in another form. And I'm looking to have the "Add New Form button" available on all pages.

I'm just learning script

Thanks for you help.

 

[My Aswer Is This]

This script will make you a copy of the Sheet named "Master"

Sub Copy_Master()
Sheets("Master").Copy after:=Sheets(Sheets.Count)
ActiveSheet.Name = "New" & Sheets.Count
End Sub