Deleting a specific AutoShape

[zinny]

i have a macro which creates a new shape, which displays a message that the current process is waiting to finish. i have a second macro which deletes this shape after the process is complete. However the name of the shape changes everytime it is created and the deleting macro fails. Is there a way to name the new shape when it is created so that i can refer to it when i delete it.

I have other shapes on the page so deleting all shapes is not an option.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[royUK]

Why not make the code more efficient so that it is faster? You are obviously activaring sheets which is more than likely unnecessaary.

[royUK]

I've just checked the code & you aren't actually naming the shape. Try this changed code, but I still think it would be unnecessary with better coding.

Please Login or Register  to view this content.

[Mallycat]

You should be able to capture a reference to the object you have just created. When the object is created, it is selected by default.

Please Login or Register  to view this content.

[zinny]

thanks roy it worked great.
when you say activating sheets slows my code what did u mean by that?

[royUK]

thanks roy it worked great.
when you say activating sheets slows my code what did u mean by that?

You autoshape mentions that the user will see sheets changing, this seems to mean that your code is selecting sheets and/or ranges. This will slow the operation of the code and is not usually necessary.

Try this code in a Standard Module, you can run this code with any sheet active & the text will be placed in A1 of Sheet3 without having to select sheet3

Please Login or Register  to view this content.

[Andy Pope]

Slight tweak to Mallycat's code in order to prevent selection of shape.

The macro recorded code incorporates the selection of the shape when added. When altering the code we can remove the need for selection and assign a reference in 1 go.

Please Login or Register  to view this content.