Load forms from another workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks Dave

I got it working

Jason Zischke

Dave Peterson said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Workbook to Open a new excel Window 1
Calling subroutine defined in another workbook (autostart workbook) 5
Excel Protection 2
Open Excel 3
Toolbars 2
Splash screen not working in hidden workbook 2
Program Question for Dave peterson 2

Back
Top