can't delete pics and textboxes

Originally Posted by carsto

I have numerous screenshots pasted and dozens of text boxes and arrows on my work sheet. When trying to delete them it takes a minimum of 5 tries.

I select the item and hit delete key, the previously active cell becomes active and the item is not deleted.
I'll do this 5 to 10 times before it finally is deleted!
I've tried selecting, right click and cut, with no success. (There is no delete option in the shortcut menu.)

Any ideas why this is happening?

You could use the Selection tool on the drawing toolbar to select all the shapes and then delete them.

Or if there are no other objects on the sheet you could use CTRL+G > Special > Objects. To select all.

Original post >
http://www.excelforum.com/excel-new-...cel-sheet.html

OR if you want to do it by macro try this link

http://www.excelforum.com/excel-prog...with-code.html

*if it work , please don't forget to mark the thread as SOLVED and RATE in thread that you used

Thank you

I don't know how they got there but there seems to be numerous duplicate EDITED pics on top of each other! How do you unknowingly copy & paste a pic exactly over the top of another??????

I just had to delete them one by one. I don't want all the pics deleted, just every single copy of specific pics.