Hi

There's a couple of things you could add in to the macro to determine
whether to show the userform or not...

Assuming that the quote number is inserted in cell A1 and is blank until the
user has completed the required details you could do:

if (range("A1").value="") then quote_details.show

Then when the quote number gets written to A1 (i.e. once the user has
finished with the form). Variations on this include reserving cell "A50000"
(or similar) for a system only use cell - set it to TRUE if the form needs
showing or FALSE once the details have been completed

if range("A50000") then quote_details.show

Hope this helps

David



"cornishbloke" wrote in message
...
Hi, once again I turn to this forum for help!

I have a workbook template (*.xlt) which, upon opening displays a
userform ("Quote_Details") into which the user enters details
(contractor name, quote number etc) of the quote they are about to
create. Once completed and the OK button is pressed this information
is sent to various places in the workbook, including headers, footers
and various cells.

The problem is that after the quote has been completed and saved it
still shows the "Quote_Details" userform upon opening.

I need the userform to only appear the first time a copy of the
template is opened and not after the copy has been named and saved. Is
this possible?

Any suggestions would be greatly appreciated.


---
Message posted from http://www.ExcelForum.com/