Advertisement
Albertodowns

Como desproteger Planilha do Excel Atualizado

Mar 29th, 2015
545
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. Sub DesprotegerPlanilha()
  2.  
  3. Dim i As Integer, j As Integer, k As Integer
  4. Dim l As Integer, m As Integer, n As Integer
  5. On Error Resume Next
  6. For i = 65 To 66
  7. For j = 65 To 66
  8. For k = 65 To 66
  9. For l = 65 To 66
  10. For m = 65 To 66
  11. For i1 = 65 To 66
  12. For i2 = 65 To 66
  13. For i3 = 65 To 66
  14. For i4 = 65 To 66
  15. For i5 = 65 To 66
  16. For i6 = 65 To 66
  17. For n = 32 To 126
  18. ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
  19. Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
  20. Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
  21. If ActiveSheet.ProtectContents = False Then
  22. MsgBox "SUA PLANILHA FOI DESBLOQUEADA COM SUCESSO "
  23. Exit Sub
  24. End If
  25. Next
  26. Next
  27. Next
  28. Next
  29. Next
  30. Next
  31. Next
  32. Next
  33. Next
  34. Next
  35. Next
  36. Next
  37.  
  38. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement