Is there VBA that will open a modeless UserForm and immediately put the focus back on the main document window (while leaving the UserForm visible)?
Google led me to a solution using 2 API calls (to SetFocus and GetActiveWindow), but is there a way that just uses VBA?
APPENDIX: In case anyone who ever reads this post wants the API solution:
Private Declare Function GetActiveWindow _
Lib “USER32” () As Long
Private Declare Function SetFocus _
Lib “USER32” (ByVal hwnd As Long) As Long
Dim lngHWnd As Long
lngHWnd = GetActiveWindow
‘Code that shows the modeless UserForm goes here.
Call SetFocus(lngHWnd)
