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

Disregard, I found this:

frmMyForm.Show vbModeless
AppActivate Application.Caption


Greg


On Aug 23, 2:47 pm, Greg Lovern wrote:
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

In the userform module:

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




Greg Lovern wrote:

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

--

Dave Peterson