| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I hide formula for acertain areas in excel
Im creating some formulas in excel sheet, I want to hide the formula and I need to give only acess for acertain cells how can I do it please help me.. -- shajizz |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I hide formula for acertain areas in excel
You need to Unlock the cell that the user can visit (it the Formatting
dialog) Then protect the worksheet and specify that users can 'visit' only unlocked cells. This is part of the dialog that show when you turn on worksheet protection - at least it is in Excel 2007 but cannot recall if possible in Excel 2003 Be aware that worksheet protection is very weak; a simple Google search will discover many free methods of breaking the protection password. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "shajizz" wrote in message ... Im creating some formulas in excel sheet, I want to hide the formula and I need to give only acess for acertain cells how can I do it please help me.. -- shajizz |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I hide formula for acertain areas in excel
Thank You Sir Bernard Liengme;3617073 Wrote: You need to Unlock the cell that the user can visit (it the Formatting dialog) Then protect the worksheet and specify that users can 'visit' only unlocked cells. This is part of the dialog that show when you turn on worksheet protection - at least it is in Excel 2007 but cannot recall if possible in Excel 2003 Be aware that worksheet protection is very weak; a simple Google search will discover many free methods of breaking the protection password. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "shajizz" wrote in message ...- Im creating some formulas in excel sheet, I want to hide the formula and I need to give only acess for acertain cells how can I do it please help me.. -- shajizz - -- shajizz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to hide a row in excel 2007 | Excel Discussion (Misc queries) | |||
| How can I hide a formula in Excel 2007 from other users seeing it | Excel Discussion (Misc queries) | |||
| How can I hide the formula in an excel sheet? | Excel Discussion (Misc queries) | |||
| Formula to spread one number over 2 or 3 or .....8 different areas | Excel Discussion (Misc queries) | |||
| Why is my formula is not calculating, it works in other areas? | Excel Discussion (Misc queries) | |||
Linear Mode
