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.