Category Archives: Technology

Technology related blogs

Unlocking macOS security features

How to add in a run anywhere option to security:

spctl --master-disable

From admin terminal obviously, and –master-enable to renable

Turning off gatekeeper auto lock:

defaults write /Library/Preferences/com.apple.GKAutoRearm -bool NO

And obviously the -bool YES to reenable the 30 day lockout

Getting Hacked

Looks like a couple of my websites fell foul of the hacking of the fast secure contact form.  Really annoying that I had to undo this.

References on both painscience.com.au and also veltman.org to the script that had inserted this into the headers of all my themes:

<script src='https://json.stringengines.com/pson.js?n=1' type='text/javascript'></script>

I think that what appears to have happened here is that the fast secure contact form was bought by a malicious programmer who then put an update that inserted this malware.  Its since been pulled by the wordpress site from the list of plugins. 

The original author did do one final update on his website that I’ve downloaded, so I’ll probably need to install that on my servers as it was a useful plugin.

Live and learn.

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