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


    Andy

    Re: Show userform open file


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


    Code
    Private Sub Workbook_Open()


userform1.show


End Sub


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


    HTH
    Ger

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

Register Yourself Login