Make non-modal form an inactive window

[Greg Lovern]

We have a form that we show non-modal. I've been asked to make it an
inactive window, like what happens if you click on a cell behind it.

The worksheet's activate method doesn't do it, and the range activate
method doesn't do it either.

Any suggestions on how I can de-activate a non-modal form?


Thanks,

Greg

 

[Greg Lovern]

Disregard, I found this:

frmMyForm.Show vbModeless
AppActivate Application.Caption


Greg

 

[Dave Peterson]

In the userform module:

Option Explicit
Private Sub UserForm_Activate()
AppActivate Application.Caption
End Sub