Workbook Open event - userform gets displayed over another workbook

I have the below code in workbook_Open event for WB1.

I have two workbooks:
1. WB1: Has all the buttons and the userforms : this is the front end for the user
2. WB2: Had all the data tables in various sheets

When the WB1 is opened, it is supposed to display a userform which has alerts related to some data in a listbox.

The problem is that this alert userform is displayed over the WB2. How to activate a specific sheet of WB1 to be shown behind the userform.

Please Login or Register  to view this content.

Sorry for the confusion. The code in my thread above was in Workbook_Open event for WB1. My objective was to display a userform when this WB1 is opened, The userform would have alerts related to some data in a listbox.

The second workbook, what I referred to as WB2, is being opened in the above code (the first line after DIM statements).

However, this code in workbook_open event was causing severe Excel Application problem. When I would open the WB1, Excel would hang. Somehow after ending Excel app from task bar 3-4 times, I got access to the workbook(WB1). I have now removed the code from Workbook_Open event. If you can identify any reason for Excel's crash, do let me know.

As of now my original problem continues.

Now I have a button in WK1 which shows the userform and runs the code in userform's initialize event. However, the problem remains. i.e. this userform is displayed over the WB2

The code now is as follows. Do let me know how to make the form appear on top of WB1, from where the userform is triggered.

Please Login or Register  to view this content.

What I feel is that during the form initialize event, I am opening the DataFile (WB2). And that remains active while the form gets displayed.

So what code do I write in the code for initialize event, so that the sheet from WB1 becomes the active sheet. I tried Thisworkbook.activate - but it has no impact.

Hi,

Try the following code which is included in the attached sample workbook tested in 32 bit Office 365.

Please Login or Register  to view this content.

Lewis

Thanks Lewis.. Your code works for me. I learnt something new in VB with this code.

JLGWhiz.. thanks to you too. Your suggestion also works and is much simpler.
These days I am bit averse of using methods like .Select, as it keeps giving me error in code. But this one works fine.

JLGWhiz, Is there any document giving guidelines on where to use .Select method and where not to?

See the following short discussion of why Select can and should be avoided most of the time: https://www.excelcampus.com/vba/how-...select-method/

Lewis