Show/hide ribbon

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


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


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

Views 490 Downloads 183

'toolbar', 'ribbon', 'Excel', 'interface'

ANmarAmdeen
448
Attachments
UI VBA-Excel
Revisions

v1.0