none
Minimize the Ribbon using VBA

Answers

  • Hello David.H _Orlando,

    I'll need to try that. God forbid that MS should make it easy and obviously in VBA to do something that you can do in the GUI.

    David H

    Hum, should I be nice or say something stupid like Bing the term RTFM?

     

    Since you not stated what version of access, I shall be nice here today!

     

    The ONE LINE of VBA code in access 2010 to minimize the ribbon is:

     

    CommandBars.ExecuteMso "MinimizeRibbon"

     

    The above does not work in access 2007, but for 2010, due to requests, it been added (so, hey, they do listen!).

     

    I do hope this one line of VBA code makes you a bit more happy, and a little less snotty at least a portion of today.

     

      ;-)

     

    Albert D. Kallal  (Access MVP)

    Edmonton, Alberta Canada

    • Marked as answer by David Holley Saturday, August 07, 2010 7:16 PM
    Saturday, August 07, 2010 6:50 PM

All replies

  • David.H _Orlando wrote:

    How would I minimize the ribbon? Not hide it, just minimize it.

    Is this what you are looking for?

    http://www.accessribbon.de/en/index.php?FAQ:18


    Peter Doering [MVP Access]

    Friday, August 06, 2010 3:32 PM
  • Hello David.H _Orlando,

    David.H _Orlando wrote:

    How would I minimize the ribbon? Not hide it, just minimize it.

    See:
    http://www.accessribbon.de/en/index.php?Downloads:15 and
    http://www.accessribbon.de/en/index.php?FAQ:19

    HTH
    Gunter


    Access FAQ: http://www.donkarl.com

          http://www.avenius.com - http://www.AccessRibbon.com
    http://www.ribboncreator.com - http://www.ribboncreator2010.com

    • Proposed as answer by Gunter Avenius Saturday, August 07, 2010 7:42 AM
    Friday, August 06, 2010 9:43 PM
  • Application.SendKeys ("^{F1}")
    Friday, August 06, 2010 10:57 PM
  • Application.SendKeys ("^{F1}")

    Every time a developer uses .SendKeys, somewhere in the world God kills a kitten. (I will go without before I use sendkeys.)

    David H
    Saturday, August 07, 2010 2:24 AM
  • Hello David.H _Orlando,

    David.H _Orlando wrote:

    How would I minimize the ribbon? Not hide it, just minimize it.

    See:
    http://www.accessribbon.de/en/index.php?Downloads:15 and
    http://www.accessribbon.de/en/index.php?FAQ:19

    HTH
    Gunter


     

    Access FAQ: http://www.donkarl.com

          http://www.avenius.com - http://www.AccessRibbon.com
    http://www.ribboncreator.com - http://www.ribboncreator2010.com


    I'll need to try that. God forbid that MS should make it easy and obviously in VBA to do something that you can do in the GUI.

    David H
    Saturday, August 07, 2010 2:25 AM
  • Application.SendKeys ("^{F1}")

    Every time a developer uses .SendKeys, somewhere in the world God kills a kitten. (I will go without before I use sendkeys.)

    David H

    Good -- I am allergic to cats.
    Saturday, August 07, 2010 3:05 AM
  • Hello David.H _Orlando,

    I'll need to try that. God forbid that MS should make it easy and obviously in VBA to do something that you can do in the GUI.

    David H

    Hum, should I be nice or say something stupid like Bing the term RTFM?

     

    Since you not stated what version of access, I shall be nice here today!

     

    The ONE LINE of VBA code in access 2010 to minimize the ribbon is:

     

    CommandBars.ExecuteMso "MinimizeRibbon"

     

    The above does not work in access 2007, but for 2010, due to requests, it been added (so, hey, they do listen!).

     

    I do hope this one line of VBA code makes you a bit more happy, and a little less snotty at least a portion of today.

     

      ;-)

     

    Albert D. Kallal  (Access MVP)

    Edmonton, Alberta Canada

    • Marked as answer by David Holley Saturday, August 07, 2010 7:16 PM
    Saturday, August 07, 2010 6:50 PM
  • 1) The version of Access that I'm using is irrelevant because all versions are exactly the same without any differences except the pretty packaging and the icons. (I so miss the 2.0 icons.) Just the tax code of 1965 is exactly the same as the tax code of 2010.

    2) If that line works and is so popular why didn't I find it when I googled every possible incarnation that I could come up with?

    3) I've got a few more 6 packs, anyone want to join me in finishing them off?


    David H
    Saturday, August 07, 2010 7:15 PM
  • I am using the above  CommandBars.ExecuteMso "MinimizeRibbon"  to hide the ribbon when the user opens certain forms.  Upon closing the form, I would like to restore the ribbon via VBA (in the OnClose? or Unload?) but have not been able to find anything on how to do this in VBA.  Using Access 2010.

    Thanks!

    Ross

    Wednesday, October 26, 2011 8:51 PM
  • Never mind.  Just discovered purely by accident.  If I use the same line of code to hide the ribbon in the OnClose property, the ribbon is restored.  Not completely intuitive, I think, that minimizing something that's minimized results in something maximized.
    Wednesday, October 26, 2011 8:54 PM
  • Never mind.  Just discovered purely by accident.  If I use the same line of code to hide the ribbon in the OnClose property, the ribbon is restored.  Not completely intuitive, I think, that minimizing something that's minimized results in something maximized.


    Way cool! Thanks for sharing that and I did not know this!

    Albert D. Kallal  (Access MVP)
    Edmonton, Alberta Canada

    Wednesday, October 26, 2011 10:50 PM