View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
David David is offline
external usenet poster
 
Posts: 1,560
Default Which 'event' to run pivot chart formatting code on file open?

Greetings
I have code to change my pivot chart type to a mix of line and column
also to refomat colours
I need to run the code so that the user sees the changes when the file is
opened Ive tried the 'workbook open' event and the chart activate event but
noy joy so far.
(Once the file is open, manualy triggering the code works perfectly)
Any ideas?
Thanks