Desproteger Hoja Excel [ Original ]

Vuelve a proteger la hoja; ahora esas celdas específicas seguirán siendo editables mientras el resto permanece bloqueado.

Sub DesprotegerHoja() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Resume Next For i = 65 To 66: For j = 65 To 66: For k = 65 To 66 For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66 For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66 For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126 ActiveSheet.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 Then MsgBox "La hoja ha sido desprotegida." Exit Sub End If Next: Next: Next: Next: Next: Next Next: Next: Next: Next: Next: Next End Sub desproteger hoja excel

A veces, cambiar el formato del archivo elimina ciertas restricciones leves. Vuelve a proteger la hoja; ahora esas celdas

| Tool | Method | Speed | Best for | |------|--------|-------|-----------| | | Brute-force hash removal | Seconds | Any Excel version | | PassFab for Excel | Dictionary + brute-force | Minutes to hours | Complex passwords | | VBA Macro Script (free) | Exploits VBA project vulnerability | Milliseconds | Files with macros | Many users believe that protecting a sheet with

Este método funciona en versiones antiguas de Excel y en algunas nuevas, pero Microsoft ha ido parcheando esta vulnerabilidad en versiones recientes de Office 365.

Many users believe that protecting a sheet with a password is like locking a safe. It is not. Excel sheet protection is more like a "Do Not Touch" sign with a simple latch. It is designed to prevent accidental changes by colleagues, not to withstand a determined attacker.

If you have access to Google Drive, this is often a magic bullet.