Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Click File > Save As.
Click a location, such as Computer or your My Site web page.
Click a folder, such as Documents or one of the folders on your OneDrive, or click Browse.
In the Save As dialog box, go to the folder you want to use, then open the Tools list and click General Options.
Enter your password, and then click OK. Enter the same password to confirm, and click OK again.
NOTE: To remove a password, follow the steps above and delete the password. Basically, just enter a blank password. You can do that for any type of password that you use in Excel.
Go To "Developer-> Visual Basic -> Double Click your sheet - > insert below code Ctrl+v -> press F5 to run macro it will give you a use-able password, insert this password.
Sub PasswordBreaker()
'Breaks worksheet password protection.Dim i As Integer, j As Integer, k As IntegerDim l As Integer, m As Integer, n As IntegerDim i1 As Integer, i2 As Integer, i3 As IntegerDim i4 As Integer, i5 As Integer, i6 As IntegerOn Error Resume NextFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)If ActiveSheet.ProtectContents = False ThenMsgBox "One usable password is " & Chr(i) & Chr(j) & _Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)Exit SubEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextEnd Sub
Hi, Kindly refer to this link: https://support.office.com/en-us/article/Password-protect-documents-workbooks-and-presentations-ef163677-3195-40ba-885a-d50fa2bb6b68
I hope it helps :)