Running a program from VB editor vs Normal way

[birdieman]

I was wondering what is the difference between running a program (with a lot of VBA in a userform) from the VB editor (clicking "run", then clicking 'run sub userform") and running the same program the normal way (just clicking the file to open and run -- there is a show.userform1 in the workbook_open event)?


I was asking because I can run the program without issue from the VB editor, while opening/running it the other way crashes excel with different errors.

thanks for looking