Hiding Formulas

1) Select the range where the formulas are.

2) Right-click and select Format cells and select the Protection tab.

3) Tick the Hidden option and click OK.

4) Right-click the worksheet and select Protect. The worksheet will be protected and the  formulas will be hidden.

Hiding all sheets except one

1) Right-click the worksheet tab that you want to hide and select Hide.

2) You will now need to lock the workbook to prevent other from unhiding the worksheets.

3) From the ribbon select Review - Protect Workbook and enter a password.

4) The workbook will now be protected and users will not be able to see the hidden sheets.

5) To hide the formulas, refer to my answer Hiding Formulas above.

Hope this helps

Sunny

Thank you