You should unload frmCases to load it again.
May be, you only hide it, but not unload?


"divya" wrote:

Hello.

I have a worksheet in which I have a button which call the foll macro
Private Sub cmdCases_Click()
Load frmCases
frmCases.Show vbModal
End Sub

When I open the worksheet for the first time, everything
works fine. However, when I exit the above code, and
then reopen the worksheet, I get the following VB errors:


"Path/File Access Error", and
"Run-Time Error 75, Cannot find the specified object"


When I hit the DEBUG button, the "Load frmcases" is
highlighted (see code, above).

can anybody help


Thanks!