View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
WCM WCM is offline
external usenet poster
 
Posts: 59
Default Pivot Chart VBA Reformat

One simple solution is a Global Variable - a binary 'switch' that is set to 1
when the formatting code begins execution, and back to 0 when the code is
done.

In the chart Calculate Event, the code only executes if the switch is set to
0.