Unprotect Excel Worksheets
Excel gives the funcitonality to lock worksheets to editing, or even to protect certain cells or ranges. This is great when you want to release a workbook to someone without worrying about them being able to mess everything up and break functionality.
Conversely it's also common to receive workbooks with protected worksheets and if you know about excel you might want to take a look at the gubbins of how something works - fortunately the protection on worksheets is weak - so here's a quick sub in VBA to place into the protected workbook and run! it will pop up with a dialog box saying that the password is xxxxx (a combination of A's and B's) but you don't need to keep a hold of this anywhere - your workbook is now unprotected!