Command to Open Ribbon

[sevanty7]

Hello


I currently have a database where the ribbon is for the most part not displayed.
However when clients get to a certain screen I would for it to become visible again so they can print the screen their on.
Is there a macro to run that will make the ribbon visible again?
Thanks for any help!

[June7]

Have you disabled the ribbon with File>Options?

Toggle the ribbon with:

DoCmd.ShowToolbar "Ribbon", acToolbarYes

DoCmd.ShowToolbar "Ribbon", acToolbarNo

However, if you are going to enable the entire ribbon for users, why bother hiding any of it to begin with? Use ribbon/QAT customization to manage what is available to users. Review: http://forums.aspfree.com/microsoft-...at-303789.html

[sevanty7]

Okay thank you, yeah it makes more sense to do it this way then the way i was doing it