Macro only to run in one sheet?

[Richbynature]

I'd like my macro only to run in one sheet, please. I have found a few useful examples on this forum of how to stop the macro if it is running on the wrong sheet. However, this makes the macro stop and I am using it to update a live data every 30s.

Is there a way to make the macro continue to run 'in the background' on that one sheet while I do things on other excel sheets. The problem is that when I'm in these sheets they are manipulated by the macro which wrecks the sheet!

If excel can't do this then please let me know (I'm trying to use it dynamically as a real time piece of SW which is not really what it was set up for?).

Thanks,

Rich

 

[Sektor]

All calculations are carried on main thread.

 

[Richbynature]

I doubt I'm as experienced with excel as you are, so to be clear, what you mean by "main thread" is that the active sheet is always the one that is operated on by the macro?

 

[energman58]

Have you tried opening a second instance of Excel? I think the latest versions (07 and 10) of Excel can run multithreaded if you have more than one core/processor but I dont know about linking more than one instance together.

 

[al_b_cnu]

Hi Rich, Welcome to the board

It's difficult to advise without seeing a sample of your code, but I assume that your macro uses something like:

Range("A1").Value = "ASDF"

This will always set cell A1 of the CURRENTLY ACTIVE SHEET to the value 'ASDF'.
If you changed it to something like:

Sub xxx()
Dim WS As Worksheet

Set WS = Sheets("Sheet1")

'... Some code here ...

WS.Range("A1").Value = "ASDF"

'... Some more code ...

End Sub

The macro will always set cell A1 of Sheet1 to the value ASDF.