2 Questions:

1. How do I make the UserForm open to be maximized in the window. I know how to change the size and position of the form but would like the form to maximize.


2. How do I print a Work Sheet that contains the data from the UserForm. For instance I do not want the user to see the Worksheet just click a Print Form Button and the underlying worksheet prints out for them.

How do I make the UserForm open to be maximized in the window. I know how to change the size and position of the form but would like the form to maximize.DoCmd.Maximize in the OnActivate event of the form.

I know that that is how I would do it in Access, but I am working with a UserForm in Excel and that command does not work. Am I getting it wrong:

Private Sub UserForm_Initialize()
DoCmd.Maximize
End Sub

I'm sorry but your OP did not specify Excel and you are in an Access forum. You might have better success in the Excel Forum (http://www.access-programmers.co.uk/forums/forumdisplay.php?f=55)