ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Turn OFF Formula Bar??? (https://www.excelbanter.com/excel-programming/308931-turn-off-formula-bar.html)

Michael Vaughan

Turn OFF Formula Bar???
 
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



Tom Ogilvy

Turn OFF Formula Bar???
 
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/3/2004 by OGILVTW
'

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

--
Regards,
Tom Ogilvy


"Michael Vaughan" wrote in message
...
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






All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com