ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My pictures appear to be hidden on my Excel spreadsheet. (https://www.excelbanter.com/excel-discussion-misc-queries/249014-my-pictures-appear-hidden-my-excel-spreadsheet.html)

gfraga99

My pictures appear to be hidden on my Excel spreadsheet.
 
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.

Paul C

My pictures appear to be hidden on my Excel spreadsheet.
 
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.

--
If this helps, please remember to click yes.


"gfraga99" wrote:

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.


excelent

My pictures appear to be hidden on my Excel spreadsheet.
 
try
Sub show()
For Each p In ActiveSheet.Shapes
p.Visible = True
Next
End Sub

"gfraga99" skrev:

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.



All times are GMT +1. The time now is 09:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com