Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You need to reorganize your code. A module can call a class module but a
class module cannot call a moulde. You need to exit the class module. Probably your solution is to split your class module up into a differnt number of functions. Then from the module routine 1) Call Class function 1 ( Init function) 2) Call Class function 2 "rick" wrote: I have a workbook that has about 50 sheets and makes extensive use of vba. However, I now have created an IribbonUI interface and am getting a Catch-22 in the various calls. In ThisWorkbook class module I have set the iribbonui to a property. The ribbon_onLoad is in another module and loads fine. However, if I try to call another subroutine (Workflow, which is the routine that activates sheets an invalidates ribbon controls) the controls will not invalidate until the -onLoad routine exits. Here is where I am stuck. Is there some way that I can get another event to fire which I can then use to call the workflow module? Summary: Used to be: Workbook_Open called -- Workflow (Error 91 Object variable not set - because Ribbon_onLoad would not run until Workbook exited). Is now: workbook_Open exit sub - RibbonUI-onLoad fires but I can't call Workflow from it. Need a workaround to be able to trigger another event or do a goto outside of the Subroutine. Thanks for your assistance. .... rick . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Call Subroutine in Excel | Excel Programming | |||
Call a subroutine using variable subroutine name | Excel Discussion (Misc queries) | |||
Can't call a subroutine | Excel Programming | |||
Call subroutine from another workbook | Excel Programming | |||
Call Subx for excel 97 Add-In subroutine | Excel Programming |