Vba hide formula bar heading in Excel

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 vba hide formula bar heading


You can find similar Excel Questions and Answer hereunder

1) How can I check if a file exists in a folder using VBA?

2) Tables in Excel VBA. How you can create table in VBA and work with them with macros

3) How can I get row count of filtered data?

4) How to disable ability to insert Rows and Columns in Excel (using VBA)?

5) How to rename multiple sheets easily with VBA

6) How can I add a Timestamp after macro execution?

7) How do I enter a formula in a cell using VBA (using Absolute Reference)?

8) How to use the trace error function in VBA

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

10) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?


Here the previous and next chapter