Hướng dẫn mở khóa file excel bằng mã
- Ấn Alt+F11
- kích đúp chuột vào sheet bị khóa
- Dán đoạn code dưới đây
- Ấn F5 để chạy mã code Run -> run sub/user form F5
Cách sửa lỗi file CSV tiếng Việt khi mở bằng Excel
15 hàm cơ bản được dùng nhiều nhất trong Excel
Sub PasswordBreaker()If ActiveSheet.ProtectContents = False ThenMsgBox "Sheet '" & ActiveSheet.Name & "' is unprotected!", vbInformationElseIf MsgBox("Sheet '" & ActiveSheet.Name & "' is protected, do you want michael1112 to unprotect it?", _vbYesNo + vbQuestion, "Unprotect Active Sheet") = vbNo Then Exit SubDim i As Integer, j As Integer, k As IntegerDim l As Integer, m As Integer, n As IntegerDim i1 As Integer, i2 As Integer, i3 As IntegerDim i4 As Integer, i5 As Integer, i6 As IntegerOn Error Resume NextFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ActiveSheet.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)Next: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextIf ActiveSheet.ProtectContents = False Then MsgBox "Sheet '" & ActiveSheet.Name & "' is unprotected!", vbInformationEnd IfEnd Sub