View Full Version : Disabling Office 2007 Ribbon and QAT with VBA
JulieB
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.
Thanks
JulieB :help
Imdabaum
10-16-2008, 01:56 PM
http://office.microsoft.com/en-us/access/HA102114151033.aspx
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.
Imdabaum
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.
Paul_Hossler
10-23-2008, 04:29 AM
Welcome to the fun world of XML
I used a sample from the CustomUI editor
http://openxmldeveloper.org/archive/2006/05/26/CustomUIeditor.aspx
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
Paul
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.