Protecting worksheets and workbooks in excel is very simple:
Protecting worksheets:
if you only want certain cells to be edited in a worksheet do the following steps
1.select the cell range you want to leave editable
2.go to Format/Cells/Protection by default the cells are marked as locked, remove the check mark from the locked box that will unlock that cell range
3. then you need to protect the worksheet
Tools/Protection / Protect worksheet
4. Ensure all three options at the top of the dialogue box are selected
5. type a password
Only the cells you unlocked are now editable, if you want the entire worksheet protected only use steps 3-5
Protecting workbooks
If you do not want all worksheet's viewable hide the worksheets first
1. Tools/Protection / Protect workbook
2. Protect the workbook structure
hopr this helps