marcchevalier
asked on
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?
Thanks,
Marc
Any suggestions?
Thanks,
Marc
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
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
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.
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.
LOVE the Ribbon and LOVE the Nav Pane :-)
ASKER
Understood.
Thanks for the responses.
Thanks for the responses.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
DoCmd.ShowToolbar "Ribbon", acToolbarNo