I created a User Form for our workbook. I saved the document and when I
reopened the workbook the user form was not there. What happened?

What do I do after I create a user form to get it to save with the workbook.

I have read alot on user forms and none of the books explain exactly what to
do with them after you create them.

I want it to show up as the first sheet in our in our workbook where the
user can fill in the User form and the information is distributed throughout
the rest of the workbook.

Do you have Excel 2007? If so, did you save it as an Excel document (xlsx)
rather than an Exel macro enabled document (xlsm)?


"Brian" wrote in message
...
I created a User Form for our workbook. I saved the document and when I
reopened the workbook the user form was not there. What happened?

What do I do after I create a user form to get it to save with the
workbook.

I have read alot on user forms and none of the books explain exactly what
to
do with them after you create them.

I want it to show up as the first sheet in our in our workbook where the
user can fill in the User form and the information is distributed
throughout
the rest of the workbook.

1. Open the workbook
2. Press Alt + F11
3. Look at the small window at top left of the screen for Project
4. Look for UserForm name. If you did not give the form a different name,
it should be the last item in the Project listing.
5. UserForms have to be called before they will appear over the worksheet.
6, To call the form, put this in the public code module1:
Sub callUF()
UserForm1.Show 'Substitute if form renamed
End Sub
7. In Excel, Tools Macro MacrosOptions provides a dialog box for
assigning a keyboard control to call the procedure "callUF". Enter a
a keyboard letter, it is case sensitive, and click OK.
8. You should now be able to press the keyboard control and see your
UserForm.




"Brian" wrote in message
...
I created a User Form for our workbook. I saved the document and when I
reopened the workbook the user form was not there. What happened?

What do I do after I create a user form to get it to save with the
workbook.

I have read alot on user forms and none of the books explain exactly what
to
do with them after you create them.

I want it to show up as the first sheet in our in our workbook where the
user can fill in the User form and the information is distributed
throughout
the rest of the workbook.

I saved it as an Excel Workbook. I see now that i can save it as a Excel
Macro Enable Workbook.

After I create the User Form I save it as an Excel Macro Enable Workbook?


"Bob Phillips" wrote:

Do you have Excel 2007? If so, did you save it as an Excel document (xlsx)
rather than an Exel macro enabled document (xlsm)?


"Brian" wrote in message
...
I created a User Form for our workbook. I saved the document and when I
reopened the workbook the user form was not there. What happened?

What do I do after I create a user form to get it to save with the
workbook.

I have read alot on user forms and none of the books explain exactly what
to
do with them after you create them.

I want it to show up as the first sheet in our in our workbook where the
user can fill in the User form and the information is distributed
throughout
the rest of the workbook.


.

Yes.

---
HTH
Bob Phillips

"Brian" wrote in message
...
I saved it as an Excel Workbook. I see now that i can save it as a Excel
Macro Enable Workbook.

After I create the User Form I save it as an Excel Macro Enable Workbook?


"Bob Phillips" wrote:

Do you have Excel 2007? If so, did you save it as an Excel document
(xlsx)
rather than an Exel macro enabled document (xlsm)?


"Brian" wrote in message
...
I created a User Form for our workbook. I saved the document and when I
reopened the workbook the user form was not there. What happened?

What do I do after I create a user form to get it to save with the
workbook.

I have read alot on user forms and none of the books explain exactly
what
to
do with them after you create them.

I want it to show up as the first sheet in our in our workbook where
the
user can fill in the User form and the information is distributed
throughout
the rest of the workbook.


.