Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • Questions on customising the ribbon

    I have, via the blog contact form received three questions from Milan, these were Can you remove the Office Button? Can you link a combobox (on the ribbon) to a cell/range? Can you link a label (on the ribbon) to a cell? The answer to No.1 was answered in the 2nd of my series on customising the ribbon. In the section under Full Dictator Application. No. 2 is yes you very much can but it is not a simple process like having a 'link' property or similar. The write-up below demonstrates how you...
  • Ribbon, Step-by-Step. Part 4 (Exploring Other Controls)

    So we've explored the file formats, created the shell for a dictator application, made some basic ribbon, tab, group and control changes and customised the Office menu. We've re-purposed some Microsoft controls to our own use and now we will be running at pace through some of the other controls available to you. I doubt we will cover all of them, but you can download a bunch of my files here , which demonstrate more of what you are learning here and also contain a 'popular' control...
  • Ribbon, Step-by-Step. Part 3 (The Office Menu and Re-purposing)

    In our first two parts we covered the file structure of Excel 2007 and some very simple customisations which, in the main, do not require any VBA code. in this part we are going to try and accomplish two things. Customisation of the Office Menu (under the office button) Re-purposing built-in controls to do other things. In the next one or two parts we will cover more details on the various controls, including Galleries and Contextual tabs and then how we can capture the ribbon object and change controls...
  • Ribbon, Step-by-Step. Part 2 (Begin Customisation)

    In the last part of this series , we went through the different file formats as a precursor to starting Ribbon customisation. You should by now have downloaded the Office 2007 Custom UI Editor , as this is the tool we will be using to customise our RibbonX and generate callbacks for VBA. We'll start with a run down of the tool itself. Remember, you need to have the .Net 2.0 framework, or above loaded on your development machine. The Office 2007 Custom UI Editor Without worrying too much about...
  • Ribbon, Step-by-Step. Part 1 (File Formats)

    I am going to endeavour to enthuse some more people into development of the new ribbon in Excel 2007 (well other applications too, but I will use Excel throughout). You will need a knowledge of XML and VBA, as these are the two technologies I will be using. I suspect it will take about 4 or 5 'sessions' to get up to some kind of understanding and I intend to cover the following: File Formats Dictator Applications Custom Tabs and the Office Menu Using Built-In Groups and Controls Using Custom...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.