Lost Graphics in Excel

[RonMB]

All of a sudden I have lost the graphics created with the Draw menu in one sheet of an ExCel workbook. Newly created ones are not displayed.

"Showall" is selected in the Tools>Options Menu.

I have reinstalled ExCel.

 

[cummings54]

The visible property of the drawings may have been set to false. Try the following:
1. from the worksheet with miissing drawings
2. launch VBA editor using the "Tools:Macro:Visual Basic Editor" menu item.
3. Open immediate window by selecting the "View: Immediate Window" menu item
4 in the immediate window pane type the following.

?activesheet.shapes.count

and press return
this will return the the number of drawing objects in the active worksheet
If its zero the worksheet is fubar. if not create and run the follwoing macro

Sub ShowMeTheDrawings()
  Dim shp As Shape
  For Each shp In ActiveSheet.Shapes
    shp.Visible = True
  Next
End Sub

HTH

 

[RonMB]

I got a zero!! At least now I know to get on with a recreation.

Thanks for your input.

RonMB