delete shape that has same shape name a cell

[beatrice25]

Hi there Guys,
does anyone know how to do this?
If I put a name of a shape into cell d6 a change macro will look for the shape that has the same name the value in D6, it will then delete it and leave all other shapes alone.
See example too if it helps

Any guidance appreciated

Thanks

Beatrice

[StephenR]

Try this:

Please Login or Register  to view this content.

[shg]

Or

Please Login or Register  to view this content.

[StephenR]

No advance on two lines. Very neat shg. (Not sure about the moniker though.)

[shg]

A mere bagatelle ...

[beatrice25]

Hi Guys,
these work great, so thank you very much.

This problem is solved

Thank you

Beatrice

[VBA Noob]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save