For question 2, I would have used this behind userform1's commandbutton1:

Option Explicit
Private Sub CommandButton1_Click()
Me.Hide
UserForm2.Show
Me.Show
End Sub


And this behind userform2's commandbutton1:
Option Explicit
Private Sub CommandButton1_Click()
Unload Me
End Sub

For question 1, what do you want the users to see instead. Maybe you can keep
that worksheet that gets updated hidden -- or show a different worksheet before
you show the form????


tress wrote:

Hi,

I have done most of the complicated parts of this task but seem to be
getting stuck on what I thought would be the simple part.

I am using Excel 2003 in a Windows NT Enviroment

Question 1

I have an Excel Document, that when you open it, it Shows the Form that I
have built but with the Excel sheet behind it, what I want is just to see
the form, I think the problem lies with when you click the ok button it
writes data from the form to the excel sheet I still want this to happen, I
just dont want the user to see this.

Question 2

I have 2 forms, what I want to do is have a button on the first form that
takes you to the second but closes the first, then a button on the second
that takes you back to the first and shuts the second.

Can anyone help with this or point me in the right direction?

Thanks

--

Dave Peterson