All Tags » excel » 2007 (RSS)

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

  • OpenOffice Is Looking Good

    Normal 0 false false false MicrosoftInternetExplorer4 I have blogged previously about what a rubbish job MS have done with Conditional Formatting in Excel 2007, but it seems it is worse than I feared. In this same file I now had CF setup as I wanted, after much trials and tribulations, but I needed to...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Mon, Nov 9 2009
    Filed under: Filed under: , , ,

  • Ribbons - Gain Without The Pain

    Normal 0 false false false MicrosoftInternetExplorer4 If you are in the habit of building or customising Excel 2007 Ribbons, there is an indispensable new tool that has just hit the market. Andy Pope has released his RibbonX Visual Designer, which can be found here . I have blogged previously about how...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Wed, Sep 9 2009
    Filed under: Filed under: , , , ,

  • Conditional Formatting In Excel 2007 - Chav or Mini?

    Yesterday I had an incredibly frustrating time. I was updating my RibbonX Autogen routine to handle more types of controls. This is driven from a worksheet, some columns of which are generated, some of which depend upon user input. So being a helpful sort of guy, I have decided to shade the input cells...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Tue, Sep 8 2009
    Filed under: Filed under: , , ,

  • Autogen’ed Ribbon Code

    Normal 0 false false false MicrosoftInternetExplorer4 In a previous post, XML Is Such A Pain , I showed the technique that I use to simplify the creation of XML code for custom ribbons. This is a handy technique, as it means that creating the XML is very simple, it is more or less a cut-and-paste job...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Mon, Aug 24 2009
    Filed under: Filed under: , , , , ,

  • XML Is Such A Pain

    Normal 0 false false false MicrosoftInternetExplorer4 Creating a custom ribbon tab in Excel 2007 is a well known technique by now, and relatively easy to achieve. I will not go into the details here, there are many examples scattered across the web, I would suggest Ron de Bruin’s pages at http...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Tue, Aug 18 2009
    Filed under: Filed under: , , , ,

  • Custom UDFs

    Normal 0 false false false MicrosoftInternetExplorer4 In Excel 2007, if you start to enter a formula, such as =I, in the formula bar, it immediately provides you with intellisense of all functions starting with I. As with normal intellisense, the more you type, the more precise the list becomes. I am...
    Posted to Excel Do, Dynamic Does by Bob Phillips on Sun, Aug 9 2009
    Filed under: Filed under: , , , ,
Page 1 of 1 (6 items)