Hidden Userform shows instead of Worksheet after Application.Goto

Circumstances:
frmEvaluationProc userform is hidden and frmSHLDRProc is shown. (Modal)
In the frmSHLDRProc module, in a button click Sub to show a protected worksheet (Table15-5), the worksheet is activated, I fill some worksheet cells with userform field values, I determine the row to display the worksheet at, I hide fmrSHLDRProc, and I use Application.Goto to display the worksheet.

Results:
The frmSHLDRProc userform disappears and the worksheet appears starting at the row I want. But, it quickly disappears, and the userform frmEvaluationProc (not even frmSHLDRProc from which I came) gains focus! I can use the taskbar to access the worksheet and it functions as it's supposed to. I double click a cell in the worksheet to return to fmrSHLDRProc. Other problems then occur, but for now, I'd just like to get the worksheet to gain focus when it should.

Below, I'm including my code in frmSHLDRProc module that executes when the user clicks the button to show the worksheet Table 15-5. Any help would be greatly appreciated!

Please Login or Register  to view this content.