how to close a userform in workbooks.open method  
Author Message
Shravan kumar





PostPosted: Visual Basic for Applications (VBA), how to close a userform in workbooks.open method Top

I am trying to open excel file which has a userform opening in Workbook_Open() method.

I need to close that userform when i open that excel workbook. should i pass any parameters to Workbooks.Open , so that the user form will be closed automatically.

Is any way to handle that.



Microsoft ISV Community Center Forums1  
 
 
ChasAA





PostPosted: Visual Basic for Applications (VBA), how to close a userform in workbooks.open method Top

Hello,

Can you not just remove the code that opens the userform . or better you could write the statement

Unload Userform1 , in the workbook open procedure

Or am I totally misunderstanding you

ChasAA