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?
Please Login or Register to view this content.
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
Register To Reply
Bookmarks