VBA Invoice Open New Window

[jocooper69]

I have a big excel vba project that creates an invoice

it was an intial template sheet, copies that to a new sheet, then fill
in the new sheet with data. All of this is front ended with forms an
the application is hidden.

At the click of a button on the form, I want the form to disappear, th
newly created invoice in a new window so that the user cant ruin th
template file, and then onclose of the new window, display the for
again.

Can someone please guide me in the right direction.
Thanks

 

[Kevin]

If you make your template file an Excel Template, Excel
will handle this for you. Just click File/SaveAs on the
Menu. Change the file type to Template and save.

When Excel opens this file, it creates a file with name
YourFileName1.xls where the template file name was
YourFileName.xlt.

Hope that helps!