View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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