Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » RibbonX (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Excel 2007 and 2010 forum. See all tags in the site
  • v2003 VBA to v2007 Ribbon

    I have written (and used for a number of years) a very controlling menu and stipulated multiple tasks with VBA. I have worked around it in 2007 using [alt][x] but am now finding this very time consuming and irritating (yes I AM old!!) It relates to a number of workbooks and worksheets and multiple changing...
    Posted to Excel 2007 and 2010 (Forum) by JWL on Fri, Dec 16 2011
  • Font Ribbon collapses when numeric value is selected, using custom ribbon

    any time I select a numeric value (i.e. number, date, etc) the Font ribbon item collapses. any time I select a string value (anything that's not numeric), the Font ribbon expands again (see image below) while the ribbon is pretty huge, it fits on screen even without the collapsing (screen resolution...
    Posted to Excel 2007 and 2010 (Forum) by ybolotin on Thu, Mar 31 2011
  • Re: Resetting a Ribbon Dropdown

    Giz You will have to capture the RibbonUI object and then invalidate it within your dropdown onAction code (RunRPNavigation) To do this set an onLoad attribute against your CustomUI in the RibbonX, for example <customUI xmlns=" http://schemas.microsoft.com/office/2006/01/customui " onLoad...
    Posted to Excel 2007 and 2010 (Forum) by Nick Hodge on Tue, Jun 1 2010
  • RibbonX question

    L.S. I would like the code for a button like the Paste button in the Clipboard Group on the Home tab. A button which you can click but also with extra options in a drop down. Can someone please hint me in the good direction thnx
    Posted to Excel 2007 and 2010 (Forum) by kaak on Mon, Mar 1 2010
  • Re: Creating OfficeMenu from scratch

    If you use startFromScratch="true" then the Office menu is stripped of all except New, Save and Exit (and the MRU), from memory. Why they have done this I do not know. What you will need to do is rebuild it using custom menus, buttons and split buttons and custom code to run the actions as...
    Posted to Excel 2007 and 2010 (Forum) by Nick Hodge on Tue, Mar 10 2009
  • Re: Customising the ribbon - hitting a wall.

    Gary I do not know why you are using the addition Namespace qualifier? This would only be necessary if you needed to use the same control name in several pieces of code. If you delete the reference to xmlns:Q="rxToolbox" from the customUI tag and then delete the 'Q' from idQ and the...
    Posted to Excel 2007 and 2010 (Forum) by Nick Hodge on Fri, Feb 20 2009
Page 1 of 1 (6 items)
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.