在excel中怎么取消保护工作簿

在excel中怎么取消保护工作簿

Sub Unprotect_Workbook()

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

Dim i7 As Integer, i8 As Integer, i9 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 i7 = 65 To 66

For i8 = 65 To 66: For i9 = 65 To 66

ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & _

Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _

Chr(i4) & Chr(i5) & Chr(i6) & Chr(i7) & Chr(i8) & Chr(i9)

If ActiveWorkbook.ProtectStructure = False Then

MsgBox "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(i7) & Chr(i8) & Chr(i9)

Exit Sub

End If

Next: Next: Next: Next: Next: Next

Next: Next: Next: Next: Next: Next

Next: Next: Next

End Sub

相关作品

为什么软件用一会就卡死,软件运行卡顿:原因与对策分析
钉的成语
365bet在线

钉的成语

📅 09-15 👁️ 1713
帶灣字成語,灣的成語,含有灣字的成語,灣字四字成語大全