Hiding Formulas in cells

[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

 

[Gord Dibben]

Robert

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

Now, Tools>Protection>Protect Sheet.

Gord Dibben Excel MVP

 

[robertguy]

Gord

Many Thanks - It Works !

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


Thanks again


Ro