Immediate Window Can't Be Viewed

R

Rich Locus

Hello Microsoft Community:

For whatever reason, my Immediate Window in Office 2002 will not show. I
have tried CTRL-G and View Immediate but the immediate window does not show
for either Access or Excel.

Any ideas? It must be system-wide because it affects both Access and Excel.
 
R

Rich Locus

I repaired the immediate window damage by doing a System Restore to about a
week ago. I had to do the System Restore in safe mode. Excel crashed on me
during a debug session, so maybe it corrupted the immediate window.
 
D

Dave Peterson

Just a guess...

Maybe the immediate window is just off the screen.

When I open the VBE and hit ctrl-g, the immediate window becomes the active
window--even if I can't see it.

Can you try opening the VBE, hit ctrl-g and (be careful) type:
msgbox 1234
(and hit enter)

Do you see the message box pop up?

If yes, then I think the immediate window is just off the screen.

With the immediate window still active (don't click out of it!), try this:
alt-spacebar
m

(This is the shortcut for choosing Move option on the title bar of the
activewindow.)

Now you can use the cursor keys to try to get the immediate window back in view
-- so you can dock it where you want.

(Move it left, right, up, down, .... until you see it <vbg>.)

=========
If this fails, you can try this technique that I've saved from a previous post:

When I screw up the layout (including the tiling), I'll just follow these
instructions from Tom Ogilvy:

What version of excel? If Version 2002 or 2003 look for

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock

you aren't deleting a file. You are deleting a value in the registry.
Windows/Excel will recreate it with default values which should restore the
original layout of the VBE.
 
R

Rich Locus

Dave:

Thanks for the post. It probably would have saved me much time!! I will
file this in my technical database.

Rich
--
Rich Locus
Logicwurks, LLC


Dave Peterson said:
Just a guess...

Maybe the immediate window is just off the screen.

When I open the VBE and hit ctrl-g, the immediate window becomes the active
window--even if I can't see it.

Can you try opening the VBE, hit ctrl-g and (be careful) type:
msgbox 1234
(and hit enter)

Do you see the message box pop up?

If yes, then I think the immediate window is just off the screen.

With the immediate window still active (don't click out of it!), try this:
alt-spacebar
m

(This is the shortcut for choosing Move option on the title bar of the
activewindow.)

Now you can use the cursor keys to try to get the immediate window back in view
-- so you can dock it where you want.

(Move it left, right, up, down, .... until you see it <vbg>.)

=========
If this fails, you can try this technique that I've saved from a previous post:

When I screw up the layout (including the tiling), I'll just follow these
instructions from Tom Ogilvy:

What version of excel? If Version 2002 or 2003 look for

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common\Dock

you aren't deleting a file. You are deleting a value in the registry.
Windows/Excel will recreate it with default values which should restore the
original layout of the VBE.
 
D

Dave Peterson

I didn't realize it was your response to your original post. I thought it was
another person recommending the registry stuff.



Rich said:
Dave:

Thanks for the post. It probably would have saved me much time!! I will
file this in my technical database.

Rich
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top