| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load forms from another workbook
Hi All,
I need to split one of my workbooks to try to get my program responding faster so I've save all my forms and modules into an Addin file so I can have it open but it hidden. How can I get my open workbook call up the forms and module form this file? Thanks in Advance Jason Zischke |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Load forms from another workbook
How about having a sub in the addin that shows the userform. Then just call
that macro from the other workbook: Application.Run "'YourAddin.xla'!SubToShowUserForm1 Jason Zischke wrote: Hi All, I need to split one of my workbooks to try to get my program responding faster so I've save all my forms and modules into an Addin file so I can have it open but it hidden. How can I get my open workbook call up the forms and module form this file? Thanks in Advance Jason Zischke -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Load forms from another workbook
Thanks Dave
I got it working Jason Zischke "Dave Peterson" wrote: How about having a sub in the addin that shows the userform. Then just call that macro from the other workbook: Application.Run "'YourAddin.xla'!SubToShowUserForm1 Jason Zischke wrote: Hi All, I need to split one of my workbooks to try to get my program responding faster so I've save all my forms and modules into an Addin file so I can have it open but it hidden. How can I get my open workbook call up the forms and module form this file? Thanks in Advance Jason Zischke -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Load form when workbook opens | Excel Discussion (Misc queries) | |||
| auto load data from one workbook to another | Excel Worksheet Functions | |||
| Close a the current workbook and load another specified workbook | Excel Programming | |||
| can i have VBA & forms etc load then unload? | Excel Programming | |||
| Excel :: Creating Entry Forms that auto load a workbook | Excel Programming | |||
Hybrid Mode
