×
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

Spreadsheet opens but is not visible

Spreadsheet opens but is not visible

Spreadsheet opens but is not visible

(OP)
Help!!!

I did something I can't find my way out of.

I wrote this code in a subroutine

sub delete_embedded_chart()
    Sheets("ChartMaster").Select
    ActiveSheet.ChartObjects(1).Select
    ActiveChart.ChartArea.Select
    ActiveWindow.Visible = False
    Selection.Delete
end sub

My spreadsheet no longer displays.  When I open it, it seems to be hinding in memory somewhere.  I went into the VB Editor and I can see all the objects on the left.  If I right-click the "view object" is greyed out.

I have tried several things to make it display, but I don't know how to get it back.  

Any ideas?

RE: Spreadsheet opens but is not visible

(OP)
Panic over, I realized that the Excel Application was open so I tried looking on the Window menu, and yes, there is an unhide choice.

I feel foolish for panicing, and don't see a way to remove this post.

RE: Spreadsheet opens but is not visible

If you really want to remove it, just Red-Flag the initial post. Then, simply explain that it is not needed.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

RE: Spreadsheet opens but is not visible

jtlearning,

Glad you solved your problem.  I noticed you were hiding the active window in your code.  If you still want to do this and subsequently restore it you could use something like the following.

Sub WindowShow()
Dim Wn As Window

  Set Wn = ActiveWindow
  Wn.Visible = False
'Do stuff here
  Wn.Visible = True
  
  Set Wn = Nothing
End Sub


You need to save a reference to the active window in order to re-set its visibility since it will no longer be the active window after it is hidden.

Hope this helps.
M. Smith

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