Maximize Userform on Workbook Active

Hi Guys,

I have a UserForm that automatically displays when a Workbook opens; the userform allows the user to create 2 new workbooks from the data they have entered. Unfortunately, the user can't select the new workbooks without closing the Userform. For this reason, I have added a minimize button to the userform:

Private Sub CommandButton24_Click()
frmMain.Hide
Application.WindowState = xlMinimized
End Sub

However, when the user reselects the workbook the userform doesn't show again and they are able to see the sheets behind it. Would it be possible to redisplay the userform if the workbook becomes active again. I have tried this code but it doesnt seem to work:

Private Sub Workbook_Activate()
frmMain.Show

End Sub

Thanks in advance for your help.