VBA code to hide ribbon in excel on Mac

New Contributor

Hi

 

I am trying to run code to hide the ribbon in excel on my mac, I have copied the code in VB editor but it doesn't seem to work, the code I used is:  

Sub hide_ribbon()

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"

End Sub

6 Replies

@Nicodemus1960 

Ribbon pages for Mac Excel 2016 and higher

Mac Excel Automation

 

Hope I was able to help you with this link.

 

NikolinoDE

I know I don't know anything (Socrates)

It has helped a little, hasn't resolved my issues though. I'll have a bit more time working with it, thanks

@Nicodemus1960 

Maybe that helps...I found it in my files by accident :).

I think it might be the file you are looking for.

I got the file from the internet a long time ago, unfortunately I can't remember where exactly.

Works with Office 2016 for MAC from version 15.17

 

Hope I was able to help you with this file.

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE  hello I am looking for the same solution. I need a Code to hide the Excel Ribbon for my Application on my Mac. Can you help me as well.

Thanks a lot 

Andreas

@AMallorca 

 

Didn't this link in a previous message help you?

Ribbon pages for Mac Excel 2016 and higher

Mac Excel Automation

 

Add. Info:

Excel for mac hide ribbon

 

You can also quickly press Ctrl + F1 at any time to turn the ribbon on or off.

These keyboard shortcuts also work for PowerPoint, Word, and all Microsoft applications. Alternatively, you can use Command + Option + R keyboard shortcut to show or hide the ribbon on Excel Mac.

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE thank you for your reply. But sorry I understand all these posts that it is possible to hide only part of the menu bar, but not hide the menu bar completely . I want my Excel application to look like its own application, with its own interface and the operator has no chance to change things anymore further in the menu bar.