Problem with Excel Screen Display Freezing

[Hercules1946]

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 ?

[AndyLitch]

I'd recommend sending periodic updates to the statusbar and maybe also include a line of code to select a cell of the active worksheet at the beginning....

[Hercules1946]

Andy
Thanks for the reply. Can you post the code required to update the status bar ?
Also: We just had one of these, and this time we got a message from Excel saying "Excel is waiting for Another Application to complete an OLE Operation". We replied to this, but remained locked out.
Eventually the Main Applications Java VM crashed, bringing Excel down with it. Is there anything we can do to prevent this?

[AndyLitch]

Status Bar :

Please Login or Register  to view this content.

Not sure about the Java issue - sorry