Thank you!

After checking the form's properties, I set ShowModal to false. I think
that's the same to your solution.

Have a nice day!
--
-Corey


"Tom Ogilvy" wrote:

Private Sub Workbook_Open()
frmReportTool.Show vbModeless
End Sub

supported in xl2000 and later

--
Regards,
Tom Ogilvy


"Corey" wrote:

Hi Folks,

I designed a Userform (frmReportTool) for users to select the predefined
operations in a Excel file.

The issue is that, once the form is loaded and show, it is always on top and
causes users are unable to select any worksheets, cells; unless it is closes.

The code I used is:

Private Sub Workbook_Open()
frmReportTool.Show
End Sub

I would like to make the form visible which users are able to select
worksheets, cells meanwhile. Thank you in advance!
--
-Corey