jondavis1987
Active Member
- Joined
- Dec 31, 2015
- Messages
- 443
- Office Version
- 2019
- Platform
- Windows
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.
VBA Code:
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