View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] curiousgeorge408@hotmail.com is offline
external usenet poster
 
Posts: 85
Default How to close Immed Window in odd situation?

I got myself into a strange situation. I don't know how; probably
some fat-finger keystrokes.

The content of the Immed Window seemed to contain an partial image of
the Excel worksheet, complete with grid lines. In that mode, I was
unable to close the Immed Window, which was overlaying the VBA window
panes. Clicking on "X" in the upper right corner did nothing.

I finally closed the workbook and reopened it. Of course, that
restored things to their normal appearance and behavior. (I could
open and close the Immed Window; and initially, it was blank.)

But for the future ....

1. Any idea how I got into that mode?

2. When I am in that mode, how can I close the Immed Window?

3. And how can I restore the Immed Window to its normal behavior,
namely: no image of an Excel worksheet?

PS: I am using Excel 2003 with VB 6.3. Unfortunately, I panicked and
closed the workbook before simply trying to execute a Debug.Print
statement to see if that cleared things up. It's kind of hard to
enter text in the VBE when most of the pane is overlayed by the Immed
Window.