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