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
excel-2003
|visual-basic
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