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!


-----Original Message-----

I have a big excel vba project that creates an invoice

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

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

Can someone please guide me in the right direction.
Thanks!


--
jocooper69
----------------------------------------------------------
--------------
jocooper69's Profile:
http://www.excelforum.com/member.php?
action=getinfo&userid=15129
View this thread:
http://www.excelforum.com/showthread...hreadid=267621

.