Hiding Formulas

To make your formulas completely invisible to a user, select the cells, choose Format | Cells, click the Protection Tab, then select the Hidden checkbox and click OK. Next, apply the same color to the text within the cells as your background, i.e. white letters on a white background are invisible. Finally, choose Tools | Protection | Protect Sheet to enable protection, which will prevent the formulas from appearing on the formula bar.