Can't Work On Other Spreadsheets While Macro Is Running

[sbernard]

I have a spreadsheet with 4 tabs. Each tab shows the status of a production line. The macro below continually scrolls from one tab to the next, with the display attached to a TV for associates to view the statuses. When the macro is running, I cannot work on any other spreadsheets. All I get is the blue spinning wheel.

Is there a way to accomplish scrolling through the tabs of the spreadsheet and allow the PC to work on other spreadsheets?

Please Login or Register  to view this content.

[6StringJazzer]

Add code as shown. When that line is executed it will allow Excel to regain control long enough to service interrupts caused by user actions. However, be wary of the user doing anything that could mess up what your macro is trying to do. In this case I don't think it's a problem, but in general this technique should only be used with a bit of analysis.

Please Login or Register  to view this content.

[TMS]

The other thing you might try is to open a second instance of Excel. So, one for your display to run in and one for you to work on.

[sbernard]

Unfortunately adding the DoEvents line of code did not solve the issue.

[6StringJazzer]

How is Timer getting a value?

The Wait statement cannot be interrupted, so even if this works you have to wait up to 5 seconds for a response.

If I get some time I will try running your code to see what happens, but I need to also see any code that deals with Timer. Having your file would be ideal.