vba hide formula bar heading in Excel

Q145. In Excel, how can I hide Formula Bar and Headings using VBA?

For example, I want to provide an "Application" like feel for my WorkSheet - I would like to avoid displaying formula bar and Column and Row Headings using VBA.

excel vba hide formula bar heading

To do it in Excel, here is the answer:

  1. OptionExplicit
  2. Public Sub ChangeDisplayStyle()
  3. ActiveWindow.DisplayHeadings = False
  4. Application.DisplayFormulaBar = False
  5. End Sub


a) Note that "DisplayHeadings" change is only for the "Active Window" and not for the WorkBook. "DisplayFormulaBar" change is for the WorkBook (any WorkBook not only Active WorkBook).

Result after Macro Execution:

excel excel vba hide formula bar heading


You can find similar Excel Questions and Answer hereunder

1) How can I set FreezePanes in a certain range using VBA?

2) How can I add a WorkSheet and name it as required using VBA?

3) Excel 2010 vba replacement of application filesearch in Excel

4) how to write a formula in Excel

5) How can I remove display of Gridlines in my worksheet using VBA?

6) How can I set non-contiguous print area using VBA?

7) How can I find the last used cell in a Column in VBA?

8) How can I convert Column numbers into Column names for use in range definition?

9) How can I get users to select a folder to save the output of my macro?

10) How to add a link in a sheet to another sheet

11) How can I activate a routine when there is a change in value of a cell?

12) How can I hide all comments in my WorkSheet using VBA?

13) How can I add Trendline to a chart using VBA?

14) How can I set up ListBox using VBA to allow users to select multiple values?

15) Vba clear the contents of an entire sheet in Excel