Disabling the Ribbon in Access 2013.

Sifting through the questions here on EE, I find mostly older, pre-Office 2013 discussions of how to control the ribbon in Access. I have no need to modify the ribbon in any way; I just want to enable/disable from VBA. This is a complex application porting up from 2007 and I just want the sucker gone (not minimized, gone) until my application determines it is needed. The old Sendkeys Ctrl-F1 works to get it out of the way, and I have tried to use version specific ExecuteMso code '13, but it does not remove it and it misbehaves whenever a print preview pops up (I use them to review, not print and do not need the ribbon.)

Any suggestions?


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
You cannot completely get rid in the Ribbon in A2013. You could in A2010.  That's just  how it is.
Embrace the Ribbon - it's here to stay and superior to the legacy menu system.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
try this

DoCmd.ShowToolbar "Ribbon", acToolbarNo
I have no need to modify the ribbon in any way; I just want to enable/disable from VBA.
Not going to happen.
The deck chairs on the Ribbon Titanic have been re-arranged, but it is still the same ship.
The best discussion of Ribbon hacking remains here.


MS has stuck us with the Ribbon.
You CANNOT get rid of it; you can attempt to minimize its functionality, but MS wants the user in charge not the dev, so it is a moderately difficult task to keep the UI sewed up shut.

For instance, anytime you use VBA to change a TableDef, the Nav Pain will fly open -- and you cannot completely rehide it until the app opens/closes again.

My advice: give up on trying to remove the Ribbon's functionality.  Ctrl-F1 it and see to it that the user never actually wants to use it -- but you can't get rid of it entirely.  You can't fight MS in this regard.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

marcchevalierAuthor Commented:
I've requested that this question be deleted for the following reason:

I was already aware that there is no APPARENT system mechanism to emphatically shutdown the ribbon until re-enabled by VBA. I was asking to find out if anyone had a less standard solution or work-around. No one did. If a request for deletion is inappropriate for these circumstances, please let me know.
A delete is inappropriate in this case.
You asked for methods to make '...the sucker gone (not minimized, gone) until my application determines it is needed.'

The answer was supplied.  There are none.
This question will be useful for others who come seeking Ribbon-destruction only to get the same answer.

MS has stuck us with the Ribbon.  Hack it, change it, customize it and live with it, because you cannot kill it.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
LOVE the Ribbon and LOVE the Nav Pane :-)
marcchevalierAuthor Commented:
Thanks for the responses.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.