none
how to close a userform in workbooks.open method RRS feed

  • Question

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

        

         

      

     

     

    Tuesday, February 7, 2006 1:22 PM

All replies

  • 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

    Friday, July 21, 2006 9:34 AM