Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding formulas
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. -- John C "Jase" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding formulas
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 On Jul 21, 1:54*pm, Jase wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HIDING FORMULAS | Excel Discussion (Misc queries) | |||
Hiding Formulas | Excel Discussion (Misc queries) | |||
Hiding Formulas | Excel Worksheet Functions | |||
Hiding formulas | Excel Discussion (Misc queries) | |||
Hiding formulas | Excel Worksheet Functions |