|
Drawn Object Woes
Hi! Is there a way to know how many drawn objects there are in spreadsheet? Can I select multiple drawn objects and delete them in VBA? Thanks -- Brian Matlac ----------------------------------------------------------------------- Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350 View this thread: http://www.excelforum.com/showthread.php?threadid=50171 |
Drawn Object Woes
You can get the number of shapes using
.shapes.count or .drawingobjects.count To delete all drawing objects use sheetname.drawingobjects.delete or loop through and just delete specific ones (in case you have buttons etc you wish to keep). Tim -- Tim Williams Palo Alto, CA "Brian Matlack" wrote in message news:Brian.Matlack.21qm2m_1137431403.3037@excelfor um-nospam.com... Hi! Is there a way to know how many drawn objects there are in a spreadsheet? Can I select multiple drawn objects and delete them in VBA? Thanks! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=501711 |
Drawn Object Woes
Thanks Tim!! You saved me alot of time. -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=501711 |
| All times are GMT +1. The time now is 01:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com