Returning Shapes to Default in Excel

Posted by Craig on Super User See other posts from Super User or by Craig
Published on 2011-02-03T12:33:34Z Indexed on 2011/02/03 15:28 UTC
Read the original article Hit count: 238

Filed under:
|

Hi,

I have around 70 shapes in a planning document i use for work, everything is fine but i am trying to add a new feature. These shapes are changed using edit points each week to show up on a map, but sometimes shape "A" may not get used in which i just want to turn it back to a default size along with all the other shapes. Does anyone know how i could achieve this via a Macro, i have tried lots of things and searched everywhere but i am at my wits end...

If a shape is not default, set all non default shapes to default size.

Thanks in advance

© Super User or respective owner

Related posts about excel-2003

Related posts about visual-basic