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.

Chip Pearson wrote:

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

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