Removing focus from a Modeless Form?
 

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.

Removing focus from a Modeless Form?
 

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

Removing focus from a Modeless Form?
 

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