How to stop displayig a cell text in the formula bar?

[megtoma]

Hello,

Does anyone know how to stop displayig a cell text in the formula bar? I would like to still see and be able to alter the text in the cell.

I would appreciate your help.

[Aflatoon]

You can set the Hidden property of the cell to True and the Locked property to False, then protect the sheet.

[megtoma]

Hello,
I tried it and when I try to change the text in the cell, it disappears.

[Aflatoon]

True - you have to re-type it. There isn't a way around that that I know of.