You could disable events at the start of the code, and enable them at
the end:

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


BorisS wrote:
This is specifically for a pivotchart, for which I did find the worksheet,
and for which I found the "chart_calculate" function. Unfortunately when I
put my macro in there to update the type and color of line, and I change the
value of the chart (select a diferent page field), it seems to go in a loop
of the macro. My guess is because the change of the chart happens, it
triggers the macro, because the macro changes something (although doesn'
actually calculate, just changes colors), the macro triggers, and so on.

Thx for any further help.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html