Removing focus from a Modeless Form?

  • Thread starter Thread starter Ian Chappel
  • Start date Start date
I

Ian Chappel

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
 
Cheers Dave, just what I needed. I wish all problems were as simple!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set focus on controls of modeless form 4
Modeless form takes 'focus' 3
Modeless form keeps taking 'focus' 5
Remove Focus from Form 1
Modeless Userform 2
How do I switch focus from a modeless user form back to the excel. 4
Activating a modeless form 2
Vying for the focus - Worksheet Vs Forms 1

Back
Top