Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is it possible to navigate to the IRibbonUI object for Excel from the
Application object? I know that I can get addressability to the Ribbon UI object with on onLoad callback, but saving that in a global variable in VBA is problematic: If any macro ever encounters an error, VBA clears all the global variables. I'd like to be able to get back reliably to my customized part of the Ribbon from my code, later, to do things like enable/disable buttons, and to "invalidate" it so that it rebuilds the dynamic menus. For the "old" code I have, using Menus, I've been able to get to the menus from the CommandBars property of the Application. But I don't see any way to navigate to the Ribbon stuff. I've searched MSDN and various forums, without finding an answer. Thanks in advance for any tips or pointers. -- Don H. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB6 and the Excel.Application Object | Excel Programming | |||
adding custom macro controls to Fluent RibbonUI | Excel Programming | |||
getting started on Fluent RibbonUI | Excel Programming | |||
excel application object | Excel Programming | |||
Access.Application.Quit - opens Access again then won't close - He | Excel Programming |