VB Code to Maximize the 2007 RIbbon

Posted on 2009-04-24
Last Modified: 2013-11-27
I know I can do this by right clicking the ribbon and selecting Maximize, but was wondering if there is code to do this.
Question by:davnao
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    I don't have A2007 but I have a dozen links on A2007 Ribbons ... would you like them?


    Author Comment

    Yes DatabaseMX, please send
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    SendKeys "^{F1}"

    Accepted Solution

    Here is what I used to be able to Show and Hide the ribbon, each assigned to it's own button.

    Private Sub cmdRibbonOff_Click()
        DoCmd.ShowToolbar "Ribbon", acToolbarNo
    End Sub
    Private Sub cmdRibbonOn_Click()
        DoCmd.ShowToolbar "Ribbon", acToolbarYes
    End Sub

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now