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.

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

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

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

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

Copy just the middle line of the code.

Application.DisplayFormulaBar = True

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

ViewImmediate 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 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