View Full Version : Disabling Office 2007 Ribbon and QAT with VBA

10-16-2008, 07:41 AM
Hi All,
I am very much a VBA newbie so please forgive any daft questions.
I currently have a Word 2003 application with VBA/macros which I hope to get running in Office 2007. The application opens ok with my custom toolbar showing in the Add_In tab but I'd like to disable the rest of the ribbon and the Quick Access toolbar if possible.
Any help would be really appreciated.
JulieB :help

10-16-2008, 01:56 PM

Basically you create a table and call it USysRibbons.

The table has these fields

ID AutoNumber Long Integer
RibbonName Text 255
RibbonXml Memo

The Elements available to hide/show in the toolbar are listed in the Excel spreadsheet that is attached here.

10-16-2008, 01:59 PM
I've also heard from another co-worker that Visual Studio 2008 has an interface that allows you to create custom toolbars with an Office plugin. I haven't tried that as I only have 2005, but if you can get a hold of VS2008 it would be something to look into.

10-23-2008, 04:29 AM
Welcome to the fun world of XML

I used a sample from the CustomUI editor


in Dictator Mode (that's what they call it)

to create a Word doc that sort of sounds like what you're looking for

Still needs customization of course: The XML and the Callbacks module, and the XML refers to Excel, but that doesn't make a difference.

But open it an see if it helps give you some ideas

Make sure to Enable macros, and one thing that I've found that seems to keep people happy (or happier at least) is to add a 'Convienance' group with some of the stardard built in commands from any and all of the other tabs and groups in an additional group on my tab