Disabling the Ribbon in Access 2013.

marcchevalier
marcchevalier used Ask the Experts™
on
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?

Thanks,

Marc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Architect / Application Developer
Top Expert 2007
Commented:
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.

mx
Top Expert 2016

Commented:
try this

DoCmd.ShowToolbar "Ribbon", acToolbarNo
Most Valuable Expert 2014
Commented:
LOL
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.

http://www.experts-exchange.com/questions/27231448/Access-2010-disable-or-modify-Quick-Access-Toolbar.html

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.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

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.
Thanks,
Marc
Most Valuable Expert 2014

Commented:
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 / Application Developer
Top Expert 2007

Commented:
LOVE the Ribbon and LOVE the Nav Pane :-)

Author

Commented:
Understood.
Thanks for the responses.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial