Public Sub RenameSheet()
Dim i As Integer
Dim n As String
i = 1
n = InputBox("Rinomina foglio", "Nuovo nome:", ActiveSheet.Name)
While i < Sheets.Count
If n = Sheets(i).Name Then
MsgBox ("Esiste già un foglio con quel nome")
Exit Sub
End If
i = i + 1
Wend
If IsNull(n) = False And n <> "" Then
ActiveSheet.Name = n
End If
End Sub