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

February 2008 - Nick Hodge's Excel Blog

  • Maybe faulting add-ins are a thing of the past?

    I was intrigued to see, under the threat from competition commissions around the World, that Microsoft are opening up parts of their code-base and engineering to competitors to make the whole operating system and main applications (Office is mentioned), work better with 3rd party products. I for one hope people like Adobe gets involved with this as a good proportion of the posts in the public GrashesGPFs group on MSFT's servers, relates to faulting add-ins opening with Excel. Hopefully good news...
  • 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...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.