What's the easisest way to remove focus from a modless form, after clicking
a button on that form? Something like "Me.RemoveFocus".

I would like to do it without using the name (or index) of the workbook
which I wish to activate, i.e.f ocus returns to the last active
workbook/window.

How about:

Private Sub CommandButton1_Click()
AppActivate Application.Caption
End Sub


Ian Chappel wrote:

What's the easisest way to remove focus from a modless form, after clicking
a button on that form? Something like "Me.RemoveFocus".

I would like to do it without using the name (or index) of the workbook
which I wish to activate, i.e.f ocus returns to the last active
workbook/window.

--

Dave Peterson

Cheers Dave, just what I needed. I wish all problems were as simple!

"Dave Peterson" wrote in message
...
How about:

Private Sub CommandButton1_Click()
AppActivate Application.Caption
End Sub


Ian Chappel wrote:

What's the easisest way to remove focus from a modless form, after
clicking
a button on that form? Something like "Me.RemoveFocus".

I would like to do it without using the name (or index) of the workbook
which I wish to activate, i.e.f ocus returns to the last active
workbook/window.

--

Dave Peterson