Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems Using Print Preview | Excel Worksheet Functions | |||
Excel spreadsheet won't print..but everything else does | Excel Discussion (Misc queries) | |||
Print Preview trouble | Excel Discussion (Misc queries) | |||
PRINT PREVIEW | Excel Discussion (Misc queries) | |||
I can't see my document - only in print preview. Any ideas? | Excel Discussion (Misc queries) |