Turn OFF Formula Bar???

  • Thread starter Michael Vaughan
  • Start date
M

Michael Vaughan

Hello Everyone,

I am having all sorts of problems today. Does anybody know how to turn off
the Formula Bar with VBA such as:

Application.DisplayStatusBar = False

I tried to create a macro and copy that... but it says to set the Status Bar
= FALSE

Well, I have that inserted into my code, but it does NOT turn off the
Formula Bar. Any thoughts???
mv
 
T

Tom Ogilvy

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/3/2004 by OGILVTW
'

'
Application.DisplayFormulaBar = False
Application.DisplayFormulaBar = True
End Sub
 
Top