Autoshapes not visible on spreadsheet but visible in print preview

Okay sometime ago I inserted some autoshapes into cells on a spreadsheet. The
autoshapes have now disappeared from the sheet but they show up in preview
and print on the paper. But I want to make them all go away. But on the
spreadsheet I can't get to them to delete them!! Help..this is driving me
crazy! Anyone have any suggestions??
Thanks
John

Maybe it's only a display thing.

Edit|goto special
Check Objects
and then hit the delete key.

If that doesn't work, maybe you could run a little macro:

Option Explicit
Sub testme02()
Dim myShape As Shape
With ActiveSheet
.AutoFilterMode = False
For Each myShape In .Shapes
myShape.Delete
Next myShape
End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

John wrote:
>
> Okay sometime ago I inserted some autoshapes into cells on a spreadsheet. The
> autoshapes have now disappeared from the sheet but they show up in preview
> and print on the paper. But I want to make them all go away. But on the
> spreadsheet I can't get to them to delete them!! Help..this is driving me
> crazy! Anyone have any suggestions??
> Thanks
> John

--

Dave Peterson

Dave
Thanks for your input. while doing that did erase some other objects that I
didn't want to erase it was easy to put them back. And it got rid of those
objects that were not visible to me. Funny thing though. I sent the sheet to
a friend who has a newer version of office and he was able to see those
objects on the spreadsheet.

"Dave Peterson" wrote:

> Maybe it's only a display thing.
>
> Edit|goto special
> Check Objects
> and then hit the delete key.
>
> If that doesn't work, maybe you could run a little macro:
>
> Option Explicit
> Sub testme02()
> Dim myShape As Shape
> With ActiveSheet
> .AutoFilterMode = False
> For Each myShape In .Shapes
> myShape.Delete
> Next myShape
> End With
> End Sub
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> John wrote:
> >
> > Okay sometime ago I inserted some autoshapes into cells on a spreadsheet. The
> > autoshapes have now disappeared from the sheet but they show up in preview
> > and print on the paper. But I want to make them all go away. But on the
> > spreadsheet I can't get to them to delete them!! Help..this is driving me
> > crazy! Anyone have any suggestions??
> > Thanks
> > John
>
> --
>
> Dave Peterson
>

Maybe it was more of a problem with the display. (Memory/driver issues???)

John wrote:
>
> Dave
> Thanks for your input. while doing that did erase some other objects that I
> didn't want to erase it was easy to put them back. And it got rid of those
> objects that were not visible to me. Funny thing though. I sent the sheet to
> a friend who has a newer version of office and he was able to see those
> objects on the spreadsheet.
>
> "Dave Peterson" wrote:
>
> > Maybe it's only a display thing.
> >
> > Edit|goto special
> > Check Objects
> > and then hit the delete key.
> >
> > If that doesn't work, maybe you could run a little macro:
> >
> > Option Explicit
> > Sub testme02()
> > Dim myShape As Shape
> > With ActiveSheet
> > .AutoFilterMode = False
> > For Each myShape In .Shapes
> > myShape.Delete
> > Next myShape
> > End With
> > End Sub
> >
> > If you're new to macros, you may want to read David McRitchie's intro at:
> > http://www.mvps.org/dmcritchie/excel/getstarted.htm
> >
> > John wrote:
> > >
> > > Okay sometime ago I inserted some autoshapes into cells on a spreadsheet. The
> > > autoshapes have now disappeared from the sheet but they show up in preview
> > > and print on the paper. But I want to make them all go away. But on the
> > > spreadsheet I can't get to them to delete them!! Help..this is driving me
> > > crazy! Anyone have any suggestions??
> > > Thanks
> > > John
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson