vba to select all autoshapes on a sheet

C

chris_culley

Hi guys,

is there a way to select all the autoshapes on a sheet in vba? At the
minute I'm looping an iterator and concatenating onto the word
"autoshape", deleting "autoshape 1", "autoshape 2", "autoshape 3"...

this is horribly inefficient and besides, stops working when a shape
has a name like "oval 5760"! I want to select all the shapes, and
delete them all in one go...


Many thanks

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: create specifically named copies of an autoshape? 4
Cell data based on autoshape color 2
Working with AutoShapes - Adding Text Vs Adding Formulas 1
Use mouse location to place autoshape via VBA 0
AutoShape Copy and Paste 4
possibility of automatically placing an autoshape using a function 1
Can I assign a macro to an autoshape using VBA? 4
Re: How to print accurately sized circles ? 3

Top