I need to open a UserForm but give focus to the workbook, not to theuser form so that the user can continue entering data in the worksheetwithout having to click on the workbook to set the focus back to theworkbook. Any suggestions?
A non-modal form can reactivate the active cell. JustPrivate Sub UserForm_Activate()ActiveCell.ActivateEnd SubSeemingly meaningless code, but it does the job (in 2003 anyway).The form will still be visible, but the sheet will have the focus.
After some experimentation this worked:UserForm1.Show vbModeless '(vbmodeless not required if form'sShowModal is set to False)AppActivate "Microsoft Excel"