![]() |
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. |
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. |
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