Minimize/Maximize Ribbon using VBA

[howard_nyc@yahoo.com]

missing from sample code....

"DisplayRibbon" does not change anything


there are five parameters provided to set values:

ShowRowColHeads As Boolean,
    ShowSheetTab As Boolean, _
    ShowGridLines As Boolean, _
    DisplayFBar As Boolean, _
    DisplayRibbon As Boolean


only four are utilized
        ActiveWindow.DisplayHeadings = ShowRowColHeads
        ActiveWindow.DisplayWorkbookTabs = ShowSheetTab
        ActiveWindow.DisplayGridlines = ShowGridLines
        Application.DisplayFormulaBar = DisplayFBar

please advise of corrected code sample

FYI: thread rating of "BAD" due to incomplete sample code... and worst of all misses the question of how to manipulate "ribbon"




https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA