View Single Post
  #1   Report Post  
ROHIT
 
Posts: n/a
Default Hide Formula in Formulabar

I want to hide Formula in Formulabar...

example:I apled formula in B2 to B6 Cell is "=IF(B335,"Pass","Fail")"
A B
1 Number Condition
2 20 Fail
3 36 Pass
4 30 Fail
5 40 Pass
6 30 Fail
7 60 Pass

Now anybody put a cell pointer in B2 to B7, "If" formula is shown in
Formulabar, I want to hide my Formula for no body can see which formula is
appliyed.

Thanking You.