Re: formulas not visible in formula bar

This usually is the case when the cell containing the formula has been
formatted as hidden & Protection is turned on. If you go to
Tools>Protection>UnProtect Sheet you can then change the
Format>Cells>Protection property to remove the Hidden attribute. The formula
will be displayed in the formula bar even if you turn protection on again.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 6/12/06 5:44 PM, in article
1150148683.072973.200660@xxxxxxxxxxxxxxxxxxxxxxxxxxxx,
"thermos.greenspot@xxxxxxxxx" <thermos.greenspot@xxxxxxxxx> wrote:

One of my machines, a MBP 2.16 with 2 GB or ram, has been having
strange problems with Excel. Clicking on a cell with the mouse does
not show the formual (or value) in the formula bar. It is just blank.
If you then hit "enter" (not "return", which would move it) it shows
and if you use the keyboard, it will show the formula for that cell.
Also, an Intel iMac user just mentioned that problem. They do not use
the same files, so I don't think it is a file issue unless they somehow
got corrupted files in different ways.

I have others that work just fine?

Any ideas? Should I reinstall Office?


.

Relevant Pages

  • Re: Insert/ delete row in protected worksheet
    ... But I don't know why you would be getting the "cell or chart etc." message ... that besides the configured protection I still get the ... Dim formula_1 As String ... Dim sheet As Worksheet ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Preserving lock on cells even when copied and pasted within a sheet
    ... Locked property is only pasted when the sheet is not protected, ... that's done the code can then reapply sheet protection. ... 'next available cell in column A ... Medium and the User clicks "Enable Macros" on the "Security ...
    (microsoft.public.excel)
  • RE: Word Templates
    ... that you have set forms protection on your template. ... you press the Tab key in the last cell of a table in one of these unprotected ... pressing the Tab key moves to the next ...
    (microsoft.public.word.docmanagement)
  • Re: tick box, how to set up
    ... Protection tab ... *AND* the linked cell for the option buttons. ... Goto Tools>Protection>Protect Sheet ...
    (microsoft.public.excel.misc)
  • Bug: ShapeSheet Protection values not getting recalculated properl
    ... The cell values displayed in the shapesheet's Protection section ... ShapeSheet in the same window" option. ... Lock properties have been set back to zero, and are now colored blue to ...
    (microsoft.public.visio.developer)