Solved: Remove a shapes [Archive]

edwin1956

10-08-2009, 10:58 AM

hi
it my first time in this forum. I problem to remove a specific shape. How i can remove it.

mdmackillop

10-08-2009, 02:34 PM

You can refer to the Shape name or index

ActiveSheet.Shapes("textbox 1").Delete
ActiveSheet.Shapes(1).Delete

edwin1956

10-08-2009, 02:37 PM

Thanks.....

mdmackillop

10-08-2009, 02:53 PM

Happy to help. You can mark a thread solved using the Thread Tools dropdown.

Welcome to VBAX