Msgbox help

I have a workbook that creates a temp workbook via workbooks.add. After the new workbook is created, I leave it open so it is the active workbook and in te original workbook vba, i create a msgbox to pop up over the temp workbook and not the original workbook. This does not work the first time I run the process, but every time after. The first time I run the process, the msgbox is not visible unless I click the original workbook. I want the temp workbook to be visible and maximized and the msgbox over it. It's like it has to wake up or something.

I realize that this may be hard to visualize, but I appreciate any help offered.

markv,

If it only has one other workbook open at a time, you could add this code to ensure that it acts the way you need it to:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

Thanks for your help, Tiger. I can get it to work, but it never works the first time. When I step through the code, it works the first time. I wonder if I need do events.