Lost Graphics in Excel
Lost Graphics in Excel
(OP)
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.
"Showall" is selected in the Tools>Options Menu.
I have reinstalled ExCel.





RE: Lost Graphics in Excel
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.
CODE
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
CODE
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
shp.Visible = True
Next
End Sub
HTH
RE: Lost Graphics in Excel
Thanks for your input.
RonMB