Msgbox help

[markv]

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.

[tigeravatar]

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:

    Workbooks.Add
    For Each wbk In Workbooks
        If wbk.Name <> ThisWorkbook.Name Then
            wbk.Activate
            MsgBox "hello"
        End If
    Next

Hope this helps,
~tigeravatar

[markv]

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.