How do I automatically start (vba) form instead of the spreadshee.

[SwimMom]

I have a complicated spreadsheet which I built a form using vb editor. Is
there a way to "make" it a executable file so I can run it from an icon
automatically opening the form instead of the spreadsheet?

 

[Beth Melton]

Yes and no. You can't create an executable file for an Excel
spreadsheet but you can a Workbook_Open macro to display the UserForm
when the workbook is opened.

In the Project Explorer open the "ThisWorkbook" module. If you select
Workbook from the Object drop down the Workbook_Open procedure will
automatically be added.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/