Modeless User Form and Worksheet Focus

[JWolf]

I'm using a Worksheet_Activate event to display a modeless user form.
The form shows but the focus remains on it.
How do I shift the focus back to the worksheet window and my chosen cell?

 

[Chip Pearson]

Use AppActivate to reactive the Excel application. E.g.,

Private Sub Worksheet_Activate()
UserForm1.Show vbModeless
AppActivate Application.Caption
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I'm using a Worksheet_Activate event to display a modeless user form.
The form shows but the focus remains on it.
How do I shift the focus back to the worksheet window and my

chosen cell?

 

[JWolf]

Thanks Chip.
BTW, I used your modFormPositioner in this module, thanks for the great app.
I couldn't get it to work with zoom over 100 or with freeze panes, it
took a while to figure out what was happening and do a workaround.