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
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