I'm trying to control the number of ways people can mess-up this worksheet.
I have several buttons that copy one object from a worksheet "FISH PARTS" and paste them onto another "THE JUMPER FISHBONE"
My question is can I prevent people from copying objects from the first worksheet if they already exist on the second?
Specific to the code below: how do I make sure "BONE_1" doesn't already exist on the worksheet "THE JUMPER FISHBONE" before allowing it to be copied from the other worksheet. And can I generate a message box that tells the user the object already exists on the page.
Sub RESTORE_BONE_1()
Sheets("FISH PARTS").Select
ActiveSheet.Shapes("BONE_1").Select
Selection.Copy
Sheets("THE JUMPER FISHBONE").Select
Range("B3").Select
ActiveSheet.Paste
End Sub
I hope this makes sense. My worksheet is attached. Any thoughts would be very much appreciated!
Thanks!
Bookmarks