How to minimize ribbon

**Obfuscated** · 07-31-2013, 01:54 AM

I know the commands to max/min the app and windows, but what would I use to minimize/maximize the ribbon in excel 2010?

**Debraj Roy** · 07-31-2013, 02:14 AM

Did you tried with Ctrl + F1

**Obfuscated** · 07-31-2013, 02:27 AM

Sorry for the lack of info. I meant to say, in a macro.

**Debraj Roy** · 07-31-2013, 02:34 AM

Ok.. so in this.. case..
Hope below will work for you..

Private Sub Workbook_Activate() 
    On Error Resume Next 
    With Application 
        .DisplayFullScreen = True 
        .CommandBars("Worksheet Menu Bar").Enabled = False 
    End With 
     
End Sub 
 
Private Sub Workbook_Deactivate() 
    On Error Resume Next 
    With Application 
        .DisplayFullScreen = False 
        .CommandBars("Worksheet Menu Bar").Enabled = True 
    End With 
     
End Sub

Attachment 254352