Remove password from excel 2016 xlsx file

REMOVE PASSWORD FROM EXCEL 2016 XLSX FILE CODE

If ActiveSheet.ProtectContents = False Then Function findPassword()Дim i As Integer, j As Integer, k As IntegerДim l As Integer, m As Integer, n As IntegerДim i1 As Integer, i2 As Integer, i3 As IntegerДim i4 As Integer, i5 As Integer, i6 As IntegerДЇor i = 65 To 66: For j = 65 To 66: For k = 65 To 66ДЇor l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66ДЇor i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66ДЇor i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ДЄctiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _Д¬hr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ I use this macro when people send me protected sheets and expect me to do something with it. Recent ClippyPoint Milestones !Д¬ongratulations and thank you to these contributors DateДЄ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.

REMOVE PASSWORD FROM EXCEL 2016 XLSX FILE CODE

NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment.

To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved.

OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

Remove password from excel 2016 xlsx file