Detect a shape in a worksheet ande delete

hi all, my question is easy, exist a way for know how many (and wich type) of shape have each sheet, i add a file (test.xlsx) in the first sheet have only 1shape, in the next sheet you see 3 shapes, but in the 3rd sheet i am not see but exist 6 shapes, exist a way for know the number of shapes and delete it?

i have a file that initially have 1 sheed, i copied it on other sheet and the spaes are duplicated, and in other sheet same duplicated, the files is big big.

Thanks

Hi,

Select Ctrl+G, choose special, select Objects, OK, then delete on your keyboard. This will remove ALL objects.

HTH
Steve

i press the keys (simultaneous):

Ctrl+G


and nothing happens.


any advice?


thanks

It's a shortcut to "Go To". Try the "F5" key.

Or, in 2007 from the Home Ribbon there is a pair of binoculars all the way to the right labelled "Find & Select". You can choose "Go To Special" from there.

Steve

ok, i tested and worked.

a dude(not know fi need open a new thread) you tell me.

same problem, not exist any code of VB or create a macro for delete:

shape1, shape2, shape3, shape4, shape5 (not shape6).

thanks