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