This is the most powerful native method. An .xlsx file is just a ZIP archive of XML files.
Este es el método más efectivo y no requiere instalar programas adicionales. Se basa en editar el código XML del archivo: desproteger hoja excel
Sub DesprotegerHoja() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer ' This tries a known pattern of weak Excel password hashes ' It does not "guess" the password; it bypasses the check. ActiveSheet.Unprotect "password" End Sub This is the most powerful native method