Category Archives: Technology

Technology related blogs

Excel Password Unlocking Code

Apparently works up to Excel 2011.  Which is good, as I’m in no rush to go to the subscription only model of 2013 onwards.

 

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) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox “One usable 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(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

Another tip

One more option:

 

1. Open a Terminal window

 

2. Check your current setting

 

sudo defaults read /Library/Preferences/com.apple.airport.bt.plist bluetoothCoexMgmt

 

It is absolutelly normal to have it stating that the setting does not exist. It just means that to revert you have just to delete it.

 

3. Set the new value to Hybrid

 

sudo defaults write /Library/Preferences/com.apple.airport.bt.plist bluetoothCoexMgmt Hybrid

 

4. reboot

 

 

To revert to the previous setting, either delete it if it did not exist…

  sudo defaults delete /Library/Preferences/com.apple.airport.bt.plist bluetoothCoexMgmt

 

 

… or re-write it its previous value:

  sudo defaults write /Library/Preferences/com.apple.airport.bt.plist bluetoothCoexMgmt <old-value>

 

Don’t forget to reboot.