Reply to thread

Message: [QUOTE="Jon Peltier, post: 4332000"] Alan - Put the code into a regular code module, not the code module that backs up the sheet. I have some code suggestions for working with charts here: [URL]http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/QuickChartVBA.html[/URL] and links to code for Pivot Tables here: [URL]http://www.geocities.com/jonpeltier/Excel/Pivots/pivotvba.htm[/URL] I would suggest making regular charts from data within pivot tables; pivot charts forget their formatting every time you refresh the underlying table. - Jon [/QUOTE]