Simple display problem...

  • Thread starter Thread starter Doug Swanson
  • Start date Start date
D

Doug Swanson

I don't use excel that much but somehow when I run it the edit bar (not sure
if that is the right name...the area where you can type text in at the top
when you click on a cell) is not visible...I've gone through all of the
properties that I can think of but I can't find where I can turn that back
on...I need to be able to click on a cell and edit the values in the text
area up in the menu...any help would be greatly appreciated.

thanks
Doug
 
Tools > Options > View tab

Under Show:
Check "Formula bar" > OK
(it's probably unchecked)

hth
Max
 
You can turn the Formula bar back on using View/Formula Bar.

If that doesn't work, it may be disabled. Type ALT-F11 to enter the
VBE, and in the Immediate Window (View/Immediate Window), type or
paste

Application.CommandBars("Formula Bar").Enabled = True

and

Application.CommandBars("Formula Bar").Visible = True

hitting ENTER after each line. Type ALT-F11 to return to XL.
 
Doug

If the formula bar(where you see the cell data) is missing completely go to
Tools>Options>View and check Formula Bar under "Show" section.

Gord Dibben XL2002
 
Thanks...that was it exactly.
Max said:
Tools > Options > View tab

Under Show:
Check "Formula bar" > OK
(it's probably unchecked)

hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------
Click to expand...
 
Back
Top