Setting Focus (1 Viewer)

[Kempes]

Hi,

I have some code that sends an email, then should display an excel message, however, once the email has been sent, the focus no longer is on excel and the taskbar application display flashes.

I have to click back onto the spreadsheet to display the message and continue.

Is there a way to set the focus back onto the worksheet?

 

[Kempes]

Think I've got it.

Activesheet.activexcontrol.activate

Seems to work OK.

 

[Kempes]

OK, I need help again.

This works fine for me, however, the spreadsheet is in UAT now so others are running it, however, at the point it says "Something is trying to send an email on your behalf.....", this message hasn't got focus and hide behind the spreadsheet. However, it runs OK for me.

Is there any way I can force this message to the front so people know there is an option to click?

 

[chergh]

Not got much to suggest on this one except take a look at http://www.cpearson.com/excel/ActivateExcelMain.aspx

if that doesn't help only other thing I can really suggest is use CDOSYS instead of creating an outlook object.