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.
To do it in Excel, here is the answer:
- Public Sub ChangeDisplayStyle()
- ActiveWindow.DisplayHeadings = False
- Application.DisplayFormulaBar = False
- 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: