Can not delete an Autoshape

[William Reitz]

I have an excel worksheet with an "Autoshape" inserted.
I want to delete the inserted shape. Excel Help states
that I should select the shape and press Delete. Sounds
simple, but when I do nothing happens, the shape is still
there. PLEASE NOTE, The worksheet is NOT protected.

I have tried to insert an Autoshape in a NEW worksheet on THIS
computer, and then tried to delete it. Same thing happens, nothing.

Tried the same thing on another computer and another copy of Excel,
everything works as it should.

Problem is only with this copy of Excel on this computer

I have selected the autoshape, then pressed the DELETE key, clicked
CUT and tried EDIT-CLEAR. Nothing seems to work

Apparently I am doing something wrong or have set some option
incorrectly. Any suggestions??

Thanks Bill
..

 

[Earl Kiosterud]

William,

This is a longshot, but I can't think of anything more likely. If there's a
cursor in the autoshape when you try to delete it, it won't.

 

[William Reitz]

Tried you suggestion. All that happened was that the selection was
canceled when I clicked CUT or pressed DELETE key.

I'm at a loss.

 

[Peo Sjoblom]

What happens if you open the same workbook on another computer,
can you delete it then?

Press Alt + F11, click insert module and paste in this

Sub testme()
For Each shp In ActiveSheet.Shapes
shp.Delete
Next
End Sub

press alt + Q to close the VBE and the press Alt + F8 to run the macro

 

[Earl Kiosterud]

William,

Hey, I wonder if you've somehow gotten more than one autoshape, one on top
of another. Doesn't seem likely, given your description of what you've
done. But we're in the tall weeds now, it seems. Peo's routine will delete
them if this is the case. Or selecting, then dragging (four-pointed
pointer) it elsewhere will expose the next one underneath. Or try turning
on the Select Objects tools (almost far left of Drawing Toolbar), and
drawing a select box around the autoshape. That'll select them all.

One way or another, it sounds as if your Excel is broken. There's always
Start - Run excel.exe /regserver. Fixes some problems. Check the knowledge
base at www.microsoft.com. Uninstall and reinstall Excel. Stand up and
turn around three times. That's about all I know.