Started up my Excel VBA project the wrong way

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

.
There is no absolute method of keeping anyone out of your code within Excel. Excel is notorious for not being secure.

If your users truly are not computer savvy, just protecting the code within the VBE will suffice for most purposes.

https://www.ozgrid.com/VBA/protect-vba-code.htm



Regarding starting the UserForm (GUI), you can create a macro and paste it into a Regular Module.

Please Login or Register  to view this content.

Then, on the Main Sheet of your project, insert a Command Button. When the button is placed on the sheet a small
window appears asking you which macro should it be attached to. Select the macro named above and click OK.

Macro name: shwForm