I have a vba code to make an identical worksheet of a template and delete the option button I use to activate it. Is there a way to have a dialogue box or something pop up where I could rename the sheet and then end the vba? It's not really a big deal for me but this is a shared file and sometimes when the other people sharing it use this template in that way they don't rename the copy to the what it should be. The name will always be unique so there's nowhere to put a value to make the name be referenced.
Sub New_Superpave2() Sheets("Superpave Template").Copy After:=ActiveSheet Sheets("Superpave Template (2)").Select ActiveSheet.Shapes.Range(Array("Option Button 2")).Select Selection.Delete End Sub