I have Form1 in workbook1 that I want to use (refer) to in workbook2.
Form1 is not known in workbook2. Both workbooks are displayed.
How do I achieve this?

My application has 5 main workbooks that will remain open for user's entire working session. Each of these 5 workbooks uses similar looking form. Do I have to copy it and then refer to it?

I know, I can call a subroutine in a workbook from another workbook. Why can't I use the same form to all workbooks. Strange!

Can I import it compile time?