PDA

View Full Version : How to close FORM in ANOTHER WORKBOOK



DaveK
08-24-2010, 08:48 AM
Hello,
I understand about USERFORMS and use them often in my workbooks.

But I need some help on this: I have an EXCEL workbook which is running a VBA, and this VBA opens another EXCEL workbook (.xlsm file) which has a macro in it. Fine. When this 2nd file opens, the macro in this 2nd file runs upon opening [Workbook_Open() code runs], which is fine... and within that code, there is a FORM which is initialized and opened.


Load Agenda_HOME
Agenda_HOME.Show False


HOW can I close that form from my VBA which is running which opened the 2nd file?

If I execute code such as this, it does not work and I get a runtime error 438, object does not support this property or method.


MasterReport_WB.Agenda_HOME.Hide