×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Lost Graphics in Excel

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.

RE: Lost Graphics in Excel

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.

CODE

?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

CODE

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

HTH

RE: Lost Graphics in Excel

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

Thanks for your input.

RonMB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources