J'ai trouvé une solution lol
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim rep
rep = InputBox("Saisir le Mot de Passe", "Protection en cas d'erreur !")
If rep <> "password" Then
Cancel = True
Else
Cancel = False
End If
End Sub