Hi all,
I am aware that I could run the following macro to completely hide ribbon and formula bar for a particular workbook.
I was wondering is there a way to make this layout a default for all workbooks opened in Excel?
Sub Hide() Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" Application.DisplayFormulaBar = False End Sub
The formula bar actually remains hidden so it's more like how could you "permanently" hide the ribbon through VBA
Last edited by Pepe Le Mokko; 12-28-2019 at 03:29 AM. Reason: Removed Indent which hided part of code
Use a PERSONAL.XLSM workbook with the middle 2 lines of code in that workbook's Workbook_Open procedure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
coqobo 
Register To Reply
Bookmarks