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

Workbook specific ribbon disabled

Latest post Mon, Jul 12 2010 9:44 AM by Gizmo. 0 replies.
  • Mon, Jul 12 2010 9:44 AM

    • Gizmo
    • Top 10 Contributor
    • Joined on Mon, Jan 21 2008
    • Hampshire, England
    • Posts 105
    • Points 1,687

    Workbook specific ribbon disabled

    I am using a workbook specific custom UI which generally works OK however...

    Following from a previous post I am defining
           Global gRibbonUI As IRibbonUI
    then using
            gRibbonUI.Invalidate
    to re-evaluate the custom tab after different processes are executed.
    However I'm finding some oddities - no comments about 2007 being one of those odditiesSmile

    Anything using a getVisible or getEnabled is rebuilt correctly after the Invalidate command. I'm using this to control the options available depending on flags within the workbook.
    Anything using a dynamic dropdown does not get rebuilt.
    If I do a save as then the custom ribbon tab is completely disabled unless I close the workbook and re-open it. The main ribbon is fine, it's only the custom bit that dies.
         Unless, that is, the custom ribbon tab is the active tab when doing the 'save as'?!?

    Any hints or has anyone overcome the rather annoying 'Save As' = 'disabled ribbon' problem.

    Thanks

    Motto? "There's always a better way" - all you have to do is find it!

    • Post Points: 5
Page 1 of 1 (1 items) | RSS
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.