I am using VBA7.0 in Excel 2010.

I opened a workbook, created a GUI form and proceeded to populate it with widgets and underlying code, all in the form, It is now quite large and unwieldy but functions great.

The only way that I can start and run this is if I open the workbook developer tab, open the visual basic tab then execute it with the little green arrow.

I've tried to separate the parts out. I'd like to just be able to start the GUI vba code. The people running this app are not very computer savvy and I'd like to keep them out of the guts of the application.

Any help, suggestions, questions for me.

Thanks
emp53