Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Hi,
Can anyone suggest me how to hide formulas on a worksheet that is used by several users to update. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
The easiest way is through sheet protection. You first have to unlock all the
cells the users will need access to (select the cells, go to format--cells, o to the protection tab, and uncheck the Locked box. Then, for all the cells that you want to 'hide' the formulas, select those and check the hidden box. Then protect the sheet, with password (otherwise the user could just unprotect). -- John C "Dinesh" wrote: Hi, Can anyone suggest me how to hide formulas on a worksheet that is used by several users to update. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Other options are...
- You could hide the row and/or column with the formulas. - You could format the formula cells to have a white font. White foreground on White background makes the formulas invisible unless the client specifically goes to that cell and looks at the Formula Bar. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "Dinesh" wrote: Hi, Can anyone suggest me how to hide formulas on a worksheet that is used by several users to update. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
What ever method of security you choose just be aware that Excel's internal
security is very weak and easily overcome. Gord Dibben MS Excel MVP On Sun, 13 Jul 2008 22:33:00 -0700, Dinesh wrote: Hi, Can anyone suggest me how to hide formulas on a worksheet that is used by several users to update. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |