well finaly i got it. and it works

the final code is:
-Private Sub cmdBestelnummerOpvragen_Click()

Workbooks.Open Filename:="C:\Documents and
Settings\leon\Bureaublad\groupagelijst.xls"
frmBestellijst.Hide

End Sub-

but the next problem accurred.
when i closed my ordernumber workbook, the workbook that i am working
in showed the sheet and not my form.
and this is what i'm preventing to show to the users, so when i close
my openend workbook my form should apear on top again.

i have fixed this by adding the following code to my workbook.

-Private Sub Workbook_WindowActivate(ByVal Wn As Window)
frmBestellijst.Show
End Sub
-


so now it works the way i want it, thanx for the help


--
eyesonly1965
------------------------------------------------------------------------
eyesonly1965's Profile: http://www.excelforum.com/member.php...o&userid=34199
View this thread: http://www.excelforum.com/showthread...hreadid=541244