Is there any way to have the results of a formula appear in the formula bar
when the cell is protected and hidden, and sheet protected? I have formulae
that retrieve text, but the cells are not wide enough to display all that
text, and the formula bar shows nothing (blank) when the cell is protected
and hidden, and the sheet is protected. I think my alternative is how excel
should work . . .

TIA

Andy

By setting the cell properties to hidden, you hide the data in the formula
bar, not in the cell.

That's what "hidden" on a protected sheet means.

Suggest you unprotect the sheet and uncheck "hidden" or widen the columns or
allow formatting of rows and set the cells to wrap text and row autofit.


Gord Dibben MS Excel MVP


On Sun, 28 Feb 2010 18:14:01 -0800, andy62
wrote:

Is there any way to have the results of a formula appear in the formula bar
when the cell is protected and hidden, and sheet protected? I have formulae
that retrieve text, but the cells are not wide enough to display all that
text, and the formula bar shows nothing (blank) when the cell is protected
and hidden, and the sheet is protected. I think my alternative is how excel
should work . . .

TIA

Andy