Re: How dare they hide something from him!
You're talking about workbook and worksheet "protection", which are just GUI settings designed largely to make data entry easier. Workbook encryption as practised by MS, does indeed encrypt the whole workbook, which is then no longer a zip file, and is non-trivial to crack.
Biting the hand that feeds IT
