View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jason Zischke Jason Zischke is offline
external usenet poster
 
Posts: 147
Default 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