My pictures appear to be hidden on my Excel spreadsheet.

  • Thread starter Thread starter gfraga99
  • Start date Start date
G

gfraga99

I created a spreadsheet with pictures in Excel 2003. My computer has been
upgrade to Excel 2007. Now when I open my spreadsheet the pictures I had
added do not appear. I know they are still there because they appear on
Print Preview and the Picture Tools menu appears. They just seem to be
invisible, which is hard because I can work with them.
 
Try using the Find and Select button on the home tab of the ribbon.

If you select Selection Pane (on the bottom of the menu) you can see all of
the object and thier visibility status. If your pictures don't have the
eyeball symbol click on the blank sheet icon or use the show all button.

That may fix you problem.
 
try
Sub show()
For Each p In ActiveSheet.Shapes
p.Visible = True
Next
End Sub

"gfraga99" skrev:
 
Back
Top