if the name of the form is frmOpenWkbk then don't declare it.

Private Sub OpenWkbk_Click()
frmOpenWkbk.Hide
Workbooks.Open Sheets("mySheet").Range("myRange").Value
End Sub

However, I would assume openWkbk command button is in the form you want to
hide, so the easiest is

Private Sub OpenWkbk_Click()
me.Hide
Workbooks.Open Sheets("mySheet").Range("myRange").Value
End sub

the Me keyword, refers to the userform that owns the code module where the
code is located.

--
Regards,
Tom Ogilvy


"Myriam" wrote:

I'm having trouble with a runtime error 91. I tried to place an "On Error
Resume Next " but it only freezes the user form. What am I missing?

Private Sub OpenWkbk_Click()
Dim frmOpenWkbk As Object
Workbooks.Open Sheets("mySheet").Range("myRange").Value
frmOpenWkbk.Hide
End Sub

Thanks for your help.