Is is possible to run a macro from another workbook?

Here's the situation:
I have a user form with a button that opens a new workbook, the dimensions of which are about half the screen size. The form covers the new workbook (even if set to modeless). So, I reduce the form's height when the new workbook is opened allowing the new workbook to be visible. When the new workbook is closed, I want the form to return to its original height. But, as far as I can see, the code to do that has to be in the original workbook in which the form resides.

How can I get the form to return to its original size when the other workbook is closed?

I have no experience of modeless forms, but, in the absence of other replies :-

1. The answer to question 1 is Yes. Use code like :-
Application.Run("BOOK1.XLS!MyMacroName")
2. You probably had the code already, but you can reset the height of a form with someting like :- UserForm1.Height = 250
3. If the workbook is closed with code you can oviously reset there. Otherwise, while searching the web for information about Class Modules, I saw one which can be set up to trap events at Application level - eg WorkBook_Close etc. which would seem appropriate here. Sorry, I do not remember where.

Hope this helps.



-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until you know how.

This code worked GREAT! Thank you