Switching back to Excel at the end of a macro

[Gadgetgav]

Hi Guys,

I have a very large macro that takes about an hour to run (this varies with each run), while I run this macro I also do other things on other programs.

My question is: is there any VBA code that I can add to the macro so it brings Excel back to the front (switching from the other program I'm running back to Excel) when it has finished so that I don't have to keep checking excel to see if it's done yet?

any help will be appreciated

Thanks in advance

Gavin

 

[Jon von der Heyden]

If I were you I'd code in a message box at the end of the routine to prompt you that it's done. It might not restore the Excel window but it will amost certainly flash on your task bar.

Example:

Sub MyMacro
    'some code here
    MsgBox "Macro is done!"
End Sub

 

[Gadgetgav]

If I were you I'd code in a message box at the end of the routine to prompt you that it's done. It might not restore the Excel window but it will amost certainly flash on your task bar.

Example:

Sub MyMacro
    'some code here
    MsgBox "Macro is done!"
End Sub

Thanks but I tried that and it shows the msgbox but doesn't flash on my taskbar so I still don't know about it until I minimise the other program, that's why I wanted to know if there was another way.