Which 'event' to run pivot chart formatting code on file open?

  • Thread starter Thread starter David
  • Start date Start date
D

David

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
 
Back
Top