Hello
Ive developed some code that processes and graphs data streamed by a Third Party Application (TPA). The processing is controlled from an added sheet in the workbook. Im using Shapes with assigned VBA procedures
in the added sheet to control everything. Generally it all works well, but Im beset with a difficult problem. After processing for some time, the whole workbook can become deactivated as far as the keyboard and mouse is concerned,
even though its still displayed on screen. This is a bit of a showstopper as the user needs to react to the data being processed (at the time data updating continues).

In most cases control can be recovered by re-clicking the Sheet from the Windows 8 taskbar. I found this statement (below) in an old Forum posting that refers to a similar problem:

"It's a strange quirk of Excel, but it has problems changing selection within a worksheet if the focus is
elsewhere (like your button). Using Activate basically sets the focus, but activating the sheet without
activating the workbook doesnt always work."

This made me wonder if my "focus may be elsewhere" ?

Is there any way that I can detect and fix this problem in my code ?