![]() |
Can't copy workseet with embedded chart
I am trying to upgrade from Office 2000 to 2003 and the only real
problem that I have encountered is when I try running one of my procedures that copies sheets from the activeworkbook into a new workbook I get the following error. Automation Error: The Object Invoked has Disconnected From its Clients Here is the line it chokes on: Estimate.Sheets(Array("Cost Sheet Report", "Product Cost Report", "Tooling", "Package", "Soft Goods", "Softgoods Material", "Purchase Parts", "Labor")).Copy after:=NewWorkBook.Sheets("Sheet3") The majority of these sheets have ActiveX controls on them so I assumed that the problem was due to that. But as I dug a little deeper I realized the error was due to one of the sheets having a chart on it. When I delete the chart everything works fine. This only happens in 2003 SP3. Any ideas? Thanks, James |
All times are GMT +1. The time now is 05:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com