VBA code to hide ribbon in excel on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-3202037%22%20slang%3D%22en-US%22%3EVBA%20code%20to%20hide%20ribbon%20in%20excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202037%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20run%20code%20to%20hide%20the%20ribbon%20in%20excel%20on%20my%20mac%2C%20I%20have%20copied%20the%20code%20in%20VB%20editor%20but%20it%20doesn't%20seem%20to%20work%2C%20the%20code%20I%20used%20is%3A%20%26nbsp%3B%3C%2FP%3E%3CP%3ESub%20hide_ribbon()%3C%2FP%3E%3CP%3EApplication.ExecuteExcel4Macro%20%22show.toolbar(%22%22Ribbon%22%22%2CFalse)%22%3C%2FP%3E%3CP%3EEnd%20Sub%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3202037%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3206186%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20code%20to%20hide%20ribbon%20in%20excel%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3206186%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1299978%22%20target%3D%22_blank%22%3E%40Nicodemus1960%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3ERibbon%20pages%20for%20Mac%20Excel%202016%20and%20higher%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.macexcel.com%2Fexamples%2Fribbonpages%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMac%20Excel%20Automation%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

3 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)