Workbook doesn't open (Lost Focus)

Originally Posted by romperstomper

I can't say I'm particularly curious - I suspect it's a DDE timeout - but the workarounds are quite simple. However, I loathe nag screens so it's one of the few things I won't assist with (like flashing cells).
I can't replicate your other issue - can you provide sample code to show the exact sequence of events?

I have a solution, I just look for the reason. My solution is to use a modeless and/or timer controled form.

Other issue

Please install the attached AddIn and look that you have any workbook in the background when you start the Macro in the AddIn.

Sub LoseControlOverActiveWorkbook()
Dim wkbBackup As Workbook
Set wkbBackup = ActiveWorkbook
Call MsgBox("Active Workbook: " & wkbBackup.Name & vbCrLf & "Please click in the following userform first on one of the 2 Buy buttons - that link to www.google.com - and then on the button Continue. The Active Workbook will then change and I will try to reactivate the old workbook, but that will fail!")
frmTrial.Show
Call MsgBox("Active Workbook: " & ActiveWorkbook.Name)
wkbBackup.Activate
Call MsgBox("Active Workbook after I tried to reactivate the saved workbook " & wkbBackup.Name & " : " & ActiveWorkbook.Name)
End Sub