My pictures appear to be hidden on my Excel spreadsheet.

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.
 
P

Paul C

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.
 
E

excelent

try
Sub show()
For Each p In ActiveSheet.Shapes
p.Visible = True
Next
End Sub

"gfraga99" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top