Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Only Show User Form Once
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show user form | Links and Linking in Excel | |||
SHow user form when opening workbook | Excel Discussion (Misc queries) | |||
Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) | |||
Show user form, leave wosksheet active | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |