| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macros to manipulate drawn objects | Excel Discussion (Misc queries) | |||
| Finding the column which a value was drawn from | Excel Discussion (Misc queries) | |||
| How to remove a drawn chart object using VBA. | Excel Programming | |||
| office xp excel drawn line gone | Charts and Charting in Excel | |||
| Prevent User from Deleting Drawn Object | Excel Programming | |||
![Brian Matlack[_46_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
