Forum Discussion

Nicodemus1960's avatar
Nicodemus1960
Copper Contributor
Feb 23, 2022

VBA code to hide ribbon in excel on Mac

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.ExecuteExc...
excel
Nicodemus1960's avatar
Nicodemus1960
Copper Contributor
Feb 23, 2022
It has helped a little, hasn't resolved my issues though. I'll have a bit more time working with it, thanks
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Feb 24, 2022

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)

  • AMallorca's avatar
    AMallorca
    Copper Contributor
    Nov 02, 2022

    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

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Nov 03, 2022

      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)

      • AMallorca's avatar
        AMallorca
        Copper Contributor
        Nov 03, 2022
        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.

Resources