If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|