Hiding Formulas in cells

R

robertguy

Hi,

can any one please help me ?

I have a cell which can either be an input cell or if no input i
entered by the user it will use the formulae already entered in th
cell. i.e. if the users inputs a figure it will over write the formul
- which is OK as other cells will make a calculation based on thi
particular cells data.

My problem is I don't want the user to know there is already a formul
in the cell but at the same time I don't want to disable the formul
bar

Does anyone know of a neat way to hide Formula

Many thanks


Ro
 
G

Gord Dibben

Robert

Format>Cells>Protection. Uncheck "locked" and check "hidden".

Now, Tools>Protection>Protect Sheet.

Gord Dibben Excel MVP
 
R

robertguy

Gord :)

Many Thanks - It Works !

This has saved me may hours of frustration - its east when you know ho
!!


Thanks again


Ro
 
Top