View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default 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