Hi All,
I have something I think is very simple. I'll preface by saying it's been about 10 years since I've used Excel VB and I'm extremely rusty. I built a very simple userform that we're calling a "simulator" that retrieves all its contents from a workbook. The form is primarily made up of comboboxes that is populated with values taken from the spreadsheet. The values are used in a complex formula and the result is displayed back on the form as a chart with text feedback. So the workbook is doing all the work, the sheet is just presenting a user-friendly interface and hiding all the complexity behind it.
I figured it would be easy enough to hide the active workbook and display only the form but it's not turning to be so simple. The trouble I'm having is I can't figure out how to close the active workbook because it's the brains for the form. I also need to consider that users may have other spreadsheets open and I don't want to interfere with those spreadsheets.
I can't figure it out. What can I do?
Bookmarks