Macro triggered by Worksheet Activate - endless loop

[Stevelin]

I have a multi-sheet workbook. The first sheet is a summary of results from the rest of the workbook. I would like this summary sheet to auto-refresh itself each time the sheet is activated. The VBA code triggered by the Worksheet/Activate event feeds some parameters out to other sheets, then copies back the results to the summary sheet of the workbook. While doing so, it keeps "reactivating" the first sheet, causing it to get into an endless loop that is triggered by the Worksheet/Activate event. Any ideas re how to avoid this? Essentially, I'd like the Worksheet/Activate event to go dormant for 15 seconds or so each time it is triggered.

 

[VoG]

You need this

Application.EnableEvents=False
'
'code here
'
Application.EnableEvents=True

 

[wigi]

As always, do not Select or Activate worksheets, unless aboslutely needed Application.EnableEvents code should not be in play here.

While getting back the result from the other sheets, why do you activate the summary sheet?

 

[Stevelin]

Thank you VoG, that did the job

Still somewhat of a VBA novice - I don't think I was actually selecting or activating the other sheets. Instead my code was doing things like range("name").copy followed by a paste/special on the first sheet, which was already active. But nonetheless it was setting off the Worksheet Activate event for some reason