Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Which 'event' to run pivot chart formatting code on file open?
I don't know why workbook_open doesn't work. You could use
Application.OnTime to run your code a short time (like 2 sec) after the workbook opens. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "David" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open file with code | Excel Discussion (Misc queries) | |||
Chart formatting randomly changes on file re-open | Charts and Charting in Excel | |||
How to Open a file with the help of a code in Excel | New Users to Excel | |||
What code do I use to attach event handler that will open my user. | Excel Worksheet Functions | |||
Code to Open Excel File Please Help | Excel Discussion (Misc queries) |