Consulting

Results 1 to 4 of 4

Thread: Disabling Office 2007 Ribbon and QAT with VBA

  1. #1

    Disabling Office 2007 Ribbon and QAT with VBA

    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

  2. #2
    VBAX Expert Imdabaum's Avatar
    Joined
    Jun 2006
    Posts
    652
    Location
    http://office.microsoft.com/en-us/ac...114151033.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.
    Someday I'll understand everything...
    Even then...I'll still pretend I'm a beginner.

  3. #3
    VBAX Expert Imdabaum's Avatar
    Joined
    Jun 2006
    Posts
    652
    Location
    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.
    Someday I'll understand everything...
    Even then...I'll still pretend I'm a beginner.

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    Welcome to the fun world of XML

    I used a sample from the CustomUI editor

    http://openxmldeveloper.org/archive/...mUIeditor.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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •