Can't toggle (or display) formula bar

[DES1944]

I used to have the Excel formula bar displayed, but after rebooting, it is
gone. The VIEW menu shows it checked, but I can't toggle that either.
Preferences set up to display it.

[VBA Noob]

Try the below code to see if this works

Sub Add_Formulabar()

Application.DisplayFormulaBar = True

End Sub

[DES1944]

Is that supposed to be entered in a spreadsheet?

DS

"VBA Noob" wrote:

>
> Try the below code to see if this works
>
> >
> > Sub Add_Formulabar()
> >
> > Application.DisplayFormulaBar = True
> >
> > End Sub
> >
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=537877
>
>

[DES1944]

I shut down Excel & restarted and the formula bar was there. Thanks.

ds

"VBA Noob" wrote:

>
> Try the below code to see if this works
>
> >
> > Sub Add_Formulabar()
> >
> > Application.DisplayFormulaBar = True
> >
> > End Sub
> >
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=537877
>
>

[TH35]

Hey, sorry for jumping in....

I have the same problem but do not know what to do with the code you so
kindly provided. Where does that get added?

Thanks very much for your time.

TH

"VBA Noob" wrote:

>
> Try the below code to see if this works
>
> >
> > Sub Add_Formulabar()
> >
> > Application.DisplayFormulaBar = True
> >
> > End Sub
> >
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=537877
>
>

[Gord Dibben]

Copy just the middle line of the code.

Application.DisplayFormulaBar = True

With Excel open, hit ALT + F11 to open VBE window.

View>Immediate Window

Paste the code and hit <ENTER>

ALT + Q to go back to Excel screen.

OK now?


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 15:34:02 -0700, TH35 <[email protected]> wrote:

>Hey, sorry for jumping in....
>
>I have the same problem but do not know what to do with the code you so
>kindly provided. Where does that get added?
>
>Thanks very much for your time.
>
>TH
>
>"VBA Noob" wrote:
>
>>
>> Try the below code to see if this works
>>
>> >
>> > Sub Add_Formulabar()
>> >
>> >
>> >
>> > End Sub
>> >
>>
>>
>> --
>> VBA Noob
>> ------------------------------------------------------------------------
>> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
>> View this thread: http://www.excelforum.com/showthread...hreadid=537877
>>
>>