The title might make you think that I lost my mind, but this is actually one of the best tricks to show your colleagues and also a transparent demonstration that all versions of Excel before Excel 2013 were lacking a great deal in security.
Ok so as the introduction suggests, this will only work in Excels prior to Excel 2013. Here’s what you do, protect a Sheet with Password: test.
Then choose the Unprotect Sheet command
But instead of writing test as a password, write zzyw or BBAb. It doesn’t matter which one you write, either one will unprotect the Sheet! Like Frank Sinatra once said, ain’t that a kick in the head J