hiding formulas

[Jase]

Is their a way to hide formulas under a password protection with in excel
sheets so the user can not see the formulas? I know how to hide formulas but
I want to only be able to access the formulas through password protection.

Jase

 

[John C]

Unprotect sheet.

go to the cell(s) that have forumlas that you don't want the users to see.
Go to menu: Format|Cells, go to protection tab, check the Hidden box. Then
protect the sheet with password. The formulas will calculate, but the actual
formula will not be visible.

 

[Pete_UK]

By default, cells in Excel are "Locked", so that when you apply
protection to a sheet their values cannot be changed, But, you can
also set them to be "Hidden", so that you cannot see the value or
formula in the formula bar. To do this, select the cells you want it
to apply to and click Format | Cells | Protection tab and check the
Hidden box.

If you want the user to be able to put some values in some cells, then
you must unlock those cells - select them, then Format | Cells |
Protection tab and uncheck the Locked box.

Then to apply password protection you need to click on Tools |
Protection | Protect Sheet, choose the things you need to protect and
type your password at the bottom - you will be prompted to re-enter
it. Make sure you can remember it.

You should be aware, though, that these security measures in Excel are
easily broken by a determined hacker.

Hope this helps.

Pete