Show userform open file

  • Hi All

    I need to display a userform which includes a label & command button when the excel file is opened. User reads message click command button to clear userform and then continue in excel

    Any help urgent


  • Re: Show userform open file

    In the excel file, in the workbook open event, place your code to show the userform... something like this....

    Private Sub Workbook_Open()
    End Sub

    This means that every time the workbook is opened it will immediately show the userform called userform1.


    There are 10 types of people in the world. Those that understand Binary and those that dont. :P

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!