It happens every now and then: 

Someone has a really neat (or broken) formula in an Excel document they share with you, but because the sheet has been locked you cannot see the code.

After a bit of digging on the web, this seems like the best solution.

Press Alt+F11

Then enter:

Run the code and the sheet will be unlocked!