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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
DoCmd.ShowToolbar "Ribbon", acToolbarNo