Berikut langkah-langkahnya : Sebagai Contoh file excel yang akan kita buka VBA Projectnya bernama lockedFile. If ActiveWorkbook. Maka dengan begini password pada file yang terkunci akan berubah menjadi 1234567890 sama dengan password pada file Excel yang telah kita buat sebelumnya.
If ActiveWorkbook.ProtectStructure = False Then
Kemudian Klik Insert - Module, Kemudian Copy dan taruh kode script dibawah ini ke modul tersebutĭim 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įor 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ĪctiveWorkbook.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)ĪctiveSheet.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)
