Category Archives: Technology

Technology related blogs

Life, Technology, Work

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

Technology

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.

Technology

Resetting everything in a mac

Luis Mercardo, thanks for this.
Luis_Mercado Oct 23, 2014 10:59 AM

I post this hoping to help those users who, like me, are experiencing high CPU usage and massive memory leaking with OS X core services and apps, leading to slow performance and battery drain.

 

I’ve tried everything mentioned, but found the right combination of steps to follow. I’ve tried this with seven different Apple computers, including mine, and has worked well so far. I applied this method yesterday to give these process a 24 hour window to fail again, so far everything good.

 

First step: disconnect any external or secondary monitors, if any is present. The video memory allocation leak can also happen if you have a system with an integrated card, like Intel, with no external monitors attached.

 

Second step: Shut down your machine and enter Safe Mode (press shift once you turn on your computer again, more info below). Once you’re there, fix your disk permissions.

 

Guide of how to access Safe Mode: OS X: What is Safe Boot, Safe Mode?

 

Third step: From Safe Mode turn off your machine again and reset your System Management Controller (SMC). There are different methods, depending on machine, to do this. To know what method applies to yours read the following guide.

 

Intel-based Macs: Resetting the System Management Controller (SMC)

 

Fourth step: Once your machine completes a full boot after resetting the SMC turn it off again and reset your PRAM (THIS IS THE MOST IMPORTANT STEP, BUT THE PREVIOUS ONES ARE ESSENTIAL FOR THIS ONE TO WORK). The PRAM stores small bits of data that indicate our Apple computer how to interact with the devices connected to it, including monitors and video cards. It also affects software.

 

To reset it you should hold the OPTION, COMMAND, P and R keys in your keyboard immediately after turning on your machine again.You’ll hear the start up chime, continue pressing the keys until the machine boots and the chime starts A SECOND TIME, then release. IF YOUR YOSEMITE INSTALLATION LOCKS UP AT A BLACK SCREEN AFTER THIS, DONT PANIC! It’s normal, just turn off your computer and let it boot again.

 

More info about PRAM: OS X Mavericks: Reset your computer’s PRAM

 

Voila, reconnect your external displays and enjoy your system.