View Single Post
  #1   Report Post  
mully
 
Posts: n/a
Default Hiding Formula's


Hi

In Excel is it possible to hide or lock a formula e.g. =IF(A2=Rate_30,A2,"")
so members of staff don't mess with it or delete it by accident - often
have to Sort the sheet during business hours - so have tried sheet protection
and locking and
hiding this is a bit cumbersome is there anything easier and quicker.

Mully