Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Ron,
I am still having some problems. I am just testing out the process before I proceed with my actual code but I am getting this error: "Runtime 91. Object variable or With block variable not set" Can you tell me why I am getting this error? Here is my xml code: <?xml version="1.0" encoding="UTF-8" standalone="yes"? <customUI onLoad="RibbonOnLoad" xmlns="http://schemas.microsoft.com/ office/2006/01/customui" <ribbon <tabs <tab idMso="TabHome" <group id="grp1" label="Group1" tag="MyPersonalGroup" <button id="btn1" label="button1" size="large" onAction="disableBtn1" getEnabled="GetEnabled" imageMso="DirectRepliesTo" / <button id="btn2" label="button2" size="large" onAction="disableBtn2" getEnabled="GetEnabled" imageMso="AccountMenu" / </group </tab </tabs </ribbon </customUI and here is my vba code: Option Explicit Dim Rib As IRibbonUI 'Callback for customUI.onLoad Sub RibbonOnLoad(ribbon As IRibbonUI) Set Rib = ribbon End Sub 'Callback for btn1 getEnabled Sub GetEnabled(control As IRibbonControl, ByRef returnedVal) returnedVal = True End Sub 'Callback for btn1 onAction Sub disableBtn1(control As IRibbonControl) Dim Rib As IRibbonUI Rib.InvalidateControl ("btn1") End Sub 'Callback for btn2 onAction Sub disableBtn2(control As IRibbonControl) Dim Rib As IRibbonUI Rib.InvalidateControl ("btn2") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ribbon and toolbar, program control | Excel Programming | |||
Current Document Name From Ribbon Control | Excel Programming | |||
How do I Disable My Buttons in a Customized added Ribbon Tab ? | Excel Programming | |||
Disable items on ribbon using VBA | Excel Programming | |||
Linking a Ribbon control with an help file | Excel Programming |