Macro form in background after start

Hi ExcelForum,

I do not understand in Excel Macro, please help me.
I am not newbie in Macro programming, but I have not been able to solve this problem yet.

Problem:
In my program when I open this Excel, the program starts with a main menu (Main Form).
From this main menu form I can choose with button any other form.

In any time I use not only one Excel file, but 3 - 4 Excel file are in open state in same time.
My problem: In this time when my program starts the main menu appers on screen not in foreground, but background covering another Excel window.

It's annoying to have to search the main menu.

How can I solve the main menu Form appers in foreground every time after I open excel-macro program?

I attach 2pictures:
- main menu covered situation
- on other picture what I would like to see

Do you have any idea?
Thanks in advance
Nokbaratja

Hi John,

You are right.
I attach a simple workbook with simple macro.

Is it good?

Thanks
nokbaratja

I think the problem lies in the wrong order of commands.
1. remove the UserForm_Initialize procedure from the MainMenu form module.
2. set the ShowModal property to True in the MainMenu form.
3. change the code of the Workbook_Open procedure:

Please Login or Register  to view this content.

.

Note that if you would swap the order of the lines to

Please Login or Register  to view this content.

the form would bind to the workbook window (let's conventionally call it AAA) that was active when the Tapszer_Teszt workbook was opened. The result is that the MainMenu does not show up with the activation of Tapszer_Teszt, but when the AAA workbook is activated.

Artik

Thanks Artik - it works

ps:
polak wegier dwa bratanki....