+ Reply to Thread
Results 1 to 4 of 4

Hide ribbon keep menu tabs or bar

  1. #1
    Registered User
    Join Date
    12-16-2014
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    24

    Hide ribbon keep menu tabs or bar

    I was wondering if anyone knows the vba code to hide the ribbon and show only the menu bar? I have tried many different things but still cannot get it to work. Please help!

    Respectfully,

    J

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide ribbon keep menu tabs or bar

    Hello Acousticlife81,

    With VBA Thisworkbook Activate Event, use the following Code;

    Please Login or Register  to view this content.
    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Hide ribbon keep menu tabs or bar

    .
    Or were you meaning this :


    .
    You want this portion to be visible : Home Insert Page Layout Formulas Data Review View Developer

    [CODE]
    Option Explicit

    Private Sub Workbook_Activate()
    If Application.CommandBars("Ribbon").Height > 100 Then
    SendKeys "^{F1}"
    DoEvents
    End If
    End Sub

    Private Sub Workbook_Deactivate()
    If Application.CommandBars("Ribbon").Height < 100 Then
    SendKeys "^{F1}"
    DoEvents
    End If
    End Sub

    [/CODE

    Hey Winon ! Good to see you again.

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hide ribbon keep menu tabs or bar

    Hello Acousticlife81,

    If you prefer you may add Buttons to the relevant Sheet to select what you would like to see, as per the sample attached.

    Regards.

    @ Logit,

    Hi there Buddy!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Hide All Ribbon Tabs except Custom Tab
    By RustyNail in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-28-2015, 03:15 PM
  2. [VBA CODE] Excel - Hide Ribbon but leave File menu
    By cityinbetween in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2014, 09:55 PM
  3. [SOLVED] Now you see it, now you don't - Use XML to hide/unhide standard Ribbon tabs?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2013, 12:05 PM
  4. Enable ribbon tabs
    By tanksalevikrant in forum Excel General
    Replies: 3
    Last Post: 12-27-2010, 08:00 AM
  5. ribbon and menu invisible
    By ffffloyd in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 11-01-2010, 05:31 AM
  6. Hide file menu ribbon excel 2010
    By DavidMorrison in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2010, 05:19 PM
  7. Excel 2007 : Customizing the ribbon/menu items.
    By LAF in forum Excel General
    Replies: 2
    Last Post: 07-29-2008, 12:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1