View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default 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