CARA MEMBUKA FILE EXCEL YG TERKUNCI DI HP ANDROID

Have you ever been in a situation where you forgot the password to your Excel file, or maybe your Android phone is locked and you can’t access it? Don’t worry, in this article we have compiled some solutions to help you unlock your files without losing your data.

Cara mengedit data Excel yang Terkunci

If you have an Excel file that is locked and you have forgotten the password, there are ways to unlock it. One of the most common methods to unlock a locked Excel file is by using the VBA code. This method involves writing a few lines of VBA code to unlock the file. Here are the steps:

1. Open the Excel file that is locked.
2. Press the Alt + F11 keys, and this will open the VBA editor.
3. Click on Insert and select Module.
4. Paste the following code:


Sub PasswordBreaker()
'Breaks worksheet password protection.
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) & i1 & i2 & i3 & i4 & i5 & i6 & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & i1 & i2 & i3 & i4 & i5 & i6 & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub


1. Press F5 and run the code.
2. A dialog box will appear with the password.
3. Enter the password and open the Excel file.

This method is quick and easy to use, but it may not work if the file is highly encrypted. If the above method doesn’t work, you can try using a third-party tool such as PassFab for Excel to remove the password protection from the Excel file.

Cara Membuka Hp Android yang Terkunci

Locked out of your Android phone? Don’t worry, here are some ways to unlock it without losing your data.

Using Find My Device

Find My Device is a built-in feature on Android devices that allows you to locate, lock, or erase your device remotely. Here are the steps to unlock your Android phone using Find My Device:

1. Go to the Find My Device website on your computer or another device.
2. Log in with the Google account associated with your locked device.
3. Select your device from the list of available devices.
4. Click on the Lock button, and follow the on-screen instructions.
5. Enter a new password, and click on Lock again to confirm.
6. Wait for a few minutes, and your device will be unlocked.

This method works well if your locked device is connected to the internet. If your device is not connected to the internet, you can still unlock it using the second method.

Using Safe Mode

Safe Mode is a diagnostic mode on Android devices that allows you to start the device with only the basic applications. Here are the steps to unlock your Android phone using Safe Mode:

1. Turn off your Android phone.
2. Press and hold the Power button until the manufacturer logo appears.
3. Release the Power button, and immediately press and hold the Volume Down button.
4. Continue holding the Volume Down button until the device finishes rebooting.
5. Your device will be in Safe Mode and all third-party apps will be disabled.
6. Go to the Settings app, and select Security & location.
7. Tap on Screen lock, and enter your pin, pattern, or password.
8. Your device will be unlocked, and you can now restart it normally.

This method is useful if you have forgotten your device password or pattern. However, it will only work if you have set a pin, pattern, or password before. If you have not set a pin, pattern, or password, you will need to use a third-party tool to unlock your device.

FAQ

1. What do I do if the VBA code method doesn’t work?

If the VBA code method doesn’t work, you can try using a third-party tool such as PassFab for Excel to remove the password protection from the Excel file.

2. Will unlocking my Android phone using Safe Mode erase all my data?

No, unlocking your Android phone using Safe Mode will not erase your data. Safe Mode is a diagnostic mode that starts the device with only the basic applications. All third-party apps will be disabled, but your data will still be intact.

Conclusion

In conclusion, forgetting your password can be stressful, but there are ways to unlock your files without losing your data. You can use the VBA code method to unlock an Excel file, or use a third-party tool such as PassFab for Excel. For unlocking your Android phone, you can use the built-in Find My Device feature or start your device in Safe Mode. Remember to always keep your passwords safe and secure to avoid these situations in the first place.