Create a form application in Excel, that doesn't open in Excel

[JRob1]

I created a form in Excel made to calculate a customer's financial savings by entering their information in text boxes and clicking a macro button which calculates everything on a seperate spreadsheet. I did not create the form using VBA. Just using cells and macro buttons.

I want to make this a "financial calculator" program that does not open in excel. Capable of putting its own icon on my desktop. Is this possible? Should I use some type of shell statement in the VBA code behind the workbook? Any answers would be appreciated. Please let me know if I need to clarify anything. Thanks.

 

[Smitty]

Welcome to the Board!

If you have a version of Excel prior to 2007 you can create what's called a Dictator application. You can eliminate command bars, menu items, etc., and make Excel look like a stand-alone application. If you do a board search you should find plenty of examples.

If you're in Excel 2007+ I think your best bet would probably be to save as a web page, because there's no getting rid of the Ribbon.

You can also do a Bingle seacrch for "Excel compiler", as there are a few programs out there that can create .exe's out of Excel workbooks.

HTH,

 

[JRob1]

Thanks Smitty. I'm going the way of the Excel compiler. Seems to be exactly what I'm looking for. In Excel 2007, the webpage conversion causes me to loose all interactivity. Thanks again!