Drawn Object Woes

[Brian Matlack]

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

 

[Tim Williams]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Brian Matlack]

Thanks Tim!! You saved me alot of time.