User form goes behind Excel Window When Message Box Pops Up

[keromero]

I have managed to code a standalone like VBA userform, by the great help of MrExcel professional users assistance and almost done.

it seems Just one issue left to manage.

The user form works such as a standalone application by the help of "Windows.Visible = False" command:

Set xl = Application
ThisWorkbook.Windows(1).Visible = False
If Workbooks.count = 1 Then

xl.Visible = False
Else
xl.Visible = True
End If

As long as the excel sheet fires and the: "Windows.Visible" goes to False mode.

Any message box pops up, shows over userform without an issue.

However in case another excel file (workbook) is opened and screen layering states as follows:

Top: Userform
Behind : Other Excel Workbook's Excel window

And a user-form related message box pops up; then userform goes behind the: "Other Workbook's Excel window". And the screen layering is as follows until message box is closed:

Top: Userform related message box
Middle : Other Workbook's Excel window
Behind: User-Form

How can we ensure all the time: "Other Workbook's Excel window" to stay behind of userform and userform related message box during any user-from related message box popup like follows:

Top: Userform related message box
Middle : User-Form
Behind: Other Workbook's Excel window

Thanks for the help.

 

[keromero]

Hi Jaafar, that's fine not an urgent issue. Take your time please.