Hi Everyone

OK I've made an invoice system for my work, and when each invoice is made, it prints it, then saves the invoice as a file to C:/Invoices/REFNUM.xls where REFNUM is the reference number generated for it. It then also saves the invoice information to the InvoiceDB page but it doesn't save each invoice item and individual cost breakdown, just the invoice total, invoice VAT etc.

The system then allows you to 'view an account'. I've got a multipage with tabs "Total Invoices (Num)" and "Outstanding Invoices (Num)" (it shows the number of each) and then the customer details. When you click on the Total Invoices / Outstanding invoices tab, there's a listbox, so that when you select a specific invoice, you are able to click on the following buttons:

- Open Invoice File, Send Invoice by E-Mail, Re-print Invoice, Edit Invoice, Delete Invoice, Mark as Paid (if it's an outstanding invoice).

Now, the open invoice file button, would allow the user to open the C:/Invoices/REFNUM.xls file, however if the userform is running it would not open the file immediately and would instead show Excel as flashing in the start bar.

This is being designed for some fairly computer-illiterate people... so I need to make things as easy as possible. So what I need is for the userform to close when they click on the open invoice file button and load up the invoice. But then I need it to re-open the userform when that invoice file is closed, so that they are not left viewing the core spreadsheets in the main invoice program again.

Is there an easy way of doing this?

When I create an invoice and it saves the file, it copies the invoice page from the program and pastes it with values rather than formulae etc. to a new workbook and saves it so I either need to know how to write into the new workbook, a macro to re-load the userform when it closes, if InvoiceCreator.xls is running or some sort of similar code needs to be written into the InvoiceCreator.xls program.

Thanks in advance, hope you all get what I mean and I've not rambled on and confused people...