Short and sweet version: Is there a way to programatically choose what RIBBON NAME is specified in the CURRENT DATABASE section of the ACCESS OPTIONS (Access 2007)? (See attached image)
So I've been hunting for this for a couple hours and turned up nothing so far. I've hit a thread here on AP (www,access-programmers,co,uk/forums/showthread.php?t=231823) that touches the topic but is not really "solved." In brief, it discusses how to MAKE RIBBONS AVAILABLE for use, but it does so using a kind of inverse logic; it renames the ribbons themselves while leaving the name in the box (in the Access Options) alone. I'm thinking that there has GOT to be a way to change the value that's in this box using VBA, but for the life of me I can't find it. Please see the attached image to get a better idea of what I mean...
So I've been hunting for this for a couple hours and turned up nothing so far. I've hit a thread here on AP (www,access-programmers,co,uk/forums/showthread.php?t=231823) that touches the topic but is not really "solved." In brief, it discusses how to MAKE RIBBONS AVAILABLE for use, but it does so using a kind of inverse logic; it renames the ribbons themselves while leaving the name in the box (in the Access Options) alone. I'm thinking that there has GOT to be a way to change the value that's in this box using VBA, but for the life of me I can't find it. Please see the attached image to get a better idea of what I mean...
Attachments
Last edited: