Hi Jens,

Try:

AppActivate Application.Caption

---
Regards,
Norman



"Jos Vens" wrote in message
...
Hi,

Is it possible when you open a modeless window (userform) to give the
focus back to the sheet you were working in, without waiting for a click
of the user in the sheet.

This lines did not do the job:

Set vSheet = ActiveSheet
myForm.Show False
vSheet.Select

or

vSheet.Activate

Thanks
Jos Vens