Toggle ribbon

[Aland2929]

Is there a way to toggle the ribon ON/OFF in Excel? I am using the following code to toggle the formula bar and would like to do the same for the ribbon instead of pressing [Alt} [F1].

Please Login or Register  to view this content.

Thanks in advance

[royUK]

You can set the view to FulScren.

This line of code will hide the Ribbon

Please Login or Register  to view this content.

As a;ways you must reverse this kind of code when the workbook closes, including switching to a different workbook & allowing for unexpected closing

[Aland2929]

Thank you Roy. Much appreciated.