Sheet Focus

[Roderick_E]

I'm using a Userform.show vbmodeless to float above the worksheet I'm using. I'm having to utilize form buttons to interact/transfer data between one workbook and another and I sometimes click between the sheets.
THE PROBLEM:
Sometimes when I click on one workbook's sheet, it seems to think it is still on there other sheet. I have to close the Userform to regain proper focus. What can I do? Thanks

 

[Roderick_E]

Fingers crossed

Unfortunately it DIDN'T work. I'm trying to force the sheet to select but it seems to often "ghost" select the another sheet, she as I manually select cells on the intended sheet, it moves around the same cells on the another sheet.
here's my code to attempt forced selection

Windows(wwsh.Parent.Name).Activate
wwbk.Activate
wwsh.Activate
wwsh.Select
wwsh.Range("A2").Select 'force selection
Application.Goto reference:=wwsh
lastrowwwsh = wwsh.Cells.Find(What:="*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
wwsh.Range("A" & lastrowwwsh + 1).Select
UserForm1.Show vbModeless

it does everything I tell it to do above but randomly still does the ghost selecting of the other sheet.

 

[Fluff]

Unfortunately I have no idea & it's going to be difficult to track down if, it works sometimes, but not others.

 

[Roderick_E]

Unfortunately I have no idea & it's going to be difficult to track down if, it works sometimes, but not others.

Actually now it seems to be consistently failing. Since it is reverting to a sheet within the Workbook where the actual macro/userform is housed, I suspect that is a clue. Still looking

 

[Roderick_E]

It has something to do with the userform because if I close it, everything reverts correctly. UGH!!! I want my userform hahaha