How to move a shape between sheets

[Guest]

End users refuse to notice the box that says "click here to sort the
data". So I created a bold clipart reminder which I stored in sheet
"STORAGE1". When the user selects menu item "VIEW THIS MONTH DATA", VB is
supposed to fetch the clipart from STORAGE1 and paste it into Sheet THIS
MONTH DATA. Then when the user clicks the sort button, the clipart goes away
and is returned to storage.

Problem is, cut and paste of the shape doesn't work. The shape changes
names!!!!! so the code generates an error. How can I tame the shape so that
it always has the same name?

TIA
Paul

 

[Norman Jones]

Hi Paul,

Why not add a shape object to the data sheet and hide it. Have the menu
selection unhide the object and have the sort button rehide it.

 

[Guest]

Too many data sheets; each would have to have it's own shape.
Paul

 

[Norman Jones]

Hi Paul,

Since you deal with 'THIS MONTH DATA' sheet, it would appear likely that a
new sheet is added each month.

Consider adding the sheet from a template sheet which holds the shape
object.