Swapping dynamically between ribbons possible ?

A

Aceware

Access 2007, converting a 2003 database application.

I've decided to bite the bullet and implement my existing custom menu for
the application as a custom ribbon. It would be "fairly" locked down - ie
just the application menu, none of the default ribbon, with one exception -
a button called "diagnostic" which could be used to drop priveleged users
back in to the full default ribbon with all its functionality.

I'm fighting my way through all sorts of online forums reading up on code
and example - but is it possible to jump between two ribbons dynamically
using vba code - or is there a better way to go about it ?
The other alternative would be a single ribbon with its properties modified
dynamically by vba code - but I am unsure if you can turn entire tabs on and
off this way (the only sample I have seen turns groups on and off)

Many thanks
Tony Epton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top