 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008XL2007, Selection.Delete deletes more than the selection
If I hold down the shift key and click on some, but not all, of the embedded charts on a worksheet, and go the VBA and do Selection.Delete, ALL the charts are deleted. I am using xl2007SP1 Can anyone else confirm this behavior? In any earlier excel version, of course, only the selected charts are deleted. Is this a known problem with Excel 2007? If so, I think it's a serious one. Brian Murphy Hi Brian - Consider it confirmed. I have routines that work only on the selected charts on a worksheet, but if there are multiple charts, and I select more than one, then all charts are processed. VBA apparently cannot distinguish unselected from selected charts in 2007. The workaround is that, if I also select a drawing object (a shape), my routines can once again distinguish between selected and unselected charts. However, I haven't figured out programmatically how to add a shape to the selected items, without the selection picking up the unselected charts. I think I've reported this as a bug. I'll check, and if I haven't I will do so. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > If I hold down the shift key and click on some, but not all, of the > embedded charts on a worksheet, and go the VBA and do [quoted text clipped - 11 lines] > > Brian Murphy Thank you for the conformation, John. It's good that it's not something I was doing wrong, but bad that Excel 2007 has such a serious problem. By the way, my own list of excel 2007 VBA glitches and workarounds might be useful to others. Is there a publicly accessible list like this anywhere? Brian Brian - I don't know of such a list, but if you forward it to me, I can add my stuff, forward it to the authorities, and post a copy. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thank you for the conformation, John. > [quoted text clipped - 6 lines] > > Brian I'll work on my list. My current wrestling match with xl2007 over is custom placement of chart point DataLabels. It's soooooo sloooowwwww. But I've still got ideas to try, yet. Brian Too bad we have to try so many new ideas to make it work the way it used to. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > I'll work on my list. > [quoted text clipped - 3 lines] > > Brian |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.