can't see formula bar

[mcanty]

I am using Excel X using Panther. When I use Excel (I'm really new at this)
there is no formula bar. I go to VIEW and click it on and off but nothing
happens. I know I can type directly into the cells, but I'm taking a college
course in Excel (and even the help talks about the formula bar) Where is it
and how can I retrieve it? Thanks ahead for any help.

Newbie

 

[JE McGimpsey]

I am using Excel X using Panther. When I use Excel (I'm really new at this)
there is no formula bar. I go to VIEW and click it on and off but nothing
happens. I know I can type directly into the cells, but I'm taking a college
course in Excel (and even the help talks about the formula bar) Where is it
and how can I retrieve it? Thanks ahead for any help.

It's possible that it has either been inadvertently disabled or moved
behind another toolbar or off-screen.

To enable the toolbar:

Type OPT-F11 to open the Visual Basic Editor (VBE). Type CMD-G to
open the Immediate Window. In the Immediate Window, type or paste

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

and

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

each followed by Return. Type OPT-F11 to return to XL.


To reset/reposition the Formula Bar:

Type OPT-F11 to open the VBE. Open the Immediate Window with CMD-G.
Type or paste

Application.CommandBars("Formula Bar").Reset

and

Application.CommandBars("Formula Bar").Top = 100

and

Application.CommandBars("Formula Bar").Left = 100

each followed by Return. Type OPT-F11 to return to XL.

 

[SharonM]

-----Original Message-----
I am using Excel X using Panther. When I use Excel (I'm really new at this)
there is no formula bar. I go to VIEW and click it on and off but nothing
happens. I know I can type directly into the cells, but I'm taking a college
course in Excel (and even the help talks about the formula bar) Where is it
and how can I retrieve it? Thanks ahead for any help.

Newbie
.
I also cannot get the formula bar to display -- this is a new occurrence (it

worked fine up until a couple of days ago). I even reinstalled Excel (twice),
but the problem persists. I do not know how to use VBE, as suggested by JE
McGimpsey. HELP!