I have a userform that loads when worksheets open and it is like the header or ribbon at the top of the spreadsheet. How do I setfocus to always be on the worksheets? I found this in a forum to set focus when userform initializes, (AppActivate Application.Caption), but as soon as I select something from the userform the focus is on it. I then have to click on the worksheet to get focus back. Is there anyway to always make the focus on the spreadsheet after selecting something on the userform? Do I need to add the (AppActivate Application.Caption) in every command on the userform? Thanks!
Bookmarks