Maybe the title is not the best but here is what I want to do.
I have a workbook that has 4 sheets in it. The first sheet is used to enter data for the installation of concrete pavers. It captures all the necessary data related to the job such as name, project, areas to be paved. It caculates the materials needed and the cost of the materials. The remaining sheets are used to do the job or submit the proposal to the client.
What I am doing is creating a userform that will be the interface to the users using the Excel workbook so they will have a form to place the data in the first sheet of the workbook. Than I will place buttons on the userform to allow the workbook to be saved or printed off. We do not want the users to know that the underlying workbook exist.
I am new to userforms and VBA but not programming. Everything that I have seen so far or read has the userform as part of the workbook. What I would like to do is have the ability to start the userform.
How do I do this? Do I use VBA?
Thanks