Hello. Another way:
Sub Group14_Click()
Dim myNum As Integer, x As Integer, newName As String, ws As Worksheet
myNum = Worksheets("Info").Cells(13, 7)
Sheets("Recipe Template").Visible = True
For x = 1 To myNum
Sheets("Recipe Template").Copy After:=Sheets(Sheets.Count)
If x = 1 Then Set ws = ActiveSheet
Next x
Sheets("Recipe Template").Visible = False
newName = InputBox("Rename your Recipe, if you created more than 1 template please rename the remaining manually.", "Theoretical & True Food Cost", "Have a Great day!")
If newName <> "" Then ws.Name = newName
End Sub
Bookmarks