Finishing an VBA program

Hi all,


how we finish a program made on excell VBA ?
i meant, we use the userform as the start of our program, we finish the code, and then, we close our Excell, and when we click on our excell file, we want that it opens on the userform made, without going to the excell sheet.

so, like it was a program independent of the excell program.

sorry my english, i tried to explain the best i know.

Hi

In "This workbook" module, try something like this.

Private Sub Workbook_Open()
UserForm1.Show
End Sub

Modify the name of your userform.

You are welcome and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.