Robert Crandal presented the following explanation :
"GS" wrote in message ...
GS expressed precisely :

The contents will display in the FormulaBar when the cell is selected. Does
this not work for you?


This will not work, because our spreadsheet/workbook is marked
as "password protected" after a few days. If you try to click on any
cell Excel displays the following message:

"The cell or chart that you are trying to change is protected
and therefore read-only"

Users are not allowed to modify/edit old workbooks, so, it's just slightly
annoying when long strings are not easily visible in these read-only
workbooks.

Robert

Well, that's just a protection setting. You could enable selecting
locked cells and they still won't be able to edit them. (By the way,
selection of locked cells is enabled by default and so removing that
was deliberate on the part of the person applying the protection!) Of
course, if the values are the result of formulas then users would see
the formula unless you chose to hide those.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion