Show/hide ribbon

Show or hide Excel ribbon from inside VBA
Needed that in one of my projects

CodeFunctionName

What is this?

Public

Tested

Original Work

' To hide ribbon
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", False)"

' Code to show ribbon
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", True)"

Views 2,749

Downloads 985

CodeID

DB ID

VBA-Excel

ANmarAmdeen
610

Attachments

Revisions

v1.0

Sunday

December

2018