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

 

[Fluff]

Does the code turn ScreenUpdating off?

 

[Roderick_E]

Does the code turn ScreenUpdating off?

Yes, but I turn it back on after the process

Application.ScreenUpdating = True
Application.StatusBar = False
Application.Calculation = xlCalculationAutomatic


UserForm1.TextBox1.BackColor = vbGreen
UserForm1.Repaint
UserForm1.TextBox1 = "Group " & UserForm1.Tag & "ed"
UserForm1.CommandButton5.Tag = "" 'reset selection
UserForm1.Repaint
AppActivate wwbk.Application
Windows(wwsh.Parent.Name).Activate
wwbk.Activate
wwsh.Activate
wwsh.Select
wwsh.Range("A2").Select 'force selection
Application.Goto reference:=wwsh
selrng = ColLetterFromNo(selcol)
selrng = selrng & 3 & ":" & selrng & 10000
Sheet2.Range(selrng) = "" 'reset
UserForm1.TextBox1 = doapp & " rows copied to " & wwbk.Name & "[" & wwsh.Name & "]"
UserForm1.TextBox1.BackColor = vbGreen

 

[Fluff]

Sorry, I should have been more specific. Do you turn screenupdating off in the Intialize of activate events of the userform?

 

[Roderick_E]

no, should I?

 

[Fluff]

No, but that could have caused the problems.

Is it the code that is writing info to the wrong sheet/workbook?

 

[Roderick_E]

No, but that could have caused the problems.

Is it the code that is writing info to the wrong sheet/workbook?

No, it just selects cells on one sheet while the cursor moves around in cells on the other sheet.

I think I fixed it with this:

AppActivate wwbk.Application
Windows(wwsh.Parent.Name).Activate
wwbk.Activate
wwsh.Activate
wwsh.Select
wwsh.Range("A2").Select 'force selection
Application.Goto reference:=wwsh

 

[Fluff]

Glad you sorted it & thanks for the feedback

 

[Roderick_E]

Thanks for helping. I only THINK it's solved. It hasn't messed up in repeated tests.

 

[Fluff]

Fingers crossed