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

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

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