Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Immediate Window Can't Be Viewed

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.
--
Rich Locus
Logicwurks, LLC
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Immediate Window Can't Be Viewed

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.
--
Rich Locus
Logicwurks, LLC


"Rich Locus" wrote:

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.
--
Rich Locus
Logicwurks, LLC

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Immediate Window Can't Be Viewed

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\Commo n\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.



Rich Locus wrote:

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.
--
Rich Locus
Logicwurks, LLC


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Immediate Window Can't Be Viewed

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" wrote:

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\Commo n\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.



Rich Locus wrote:

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.
--
Rich Locus
Logicwurks, LLC


--

Dave Peterson
.

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Immediate Window Can't Be Viewed

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



Rich Locus wrote:

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" wrote:

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\Commo n\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.



Rich Locus wrote:

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.
--
Rich Locus
Logicwurks, LLC


--

Dave Peterson
.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Some of the changes cannot be viewed in track changes history. Maureen C Setting up and Configuration of Excel 0 March 13th 10 01:33 PM
How do I password protect a SS & allow it to be viewed by others EssexRam Excel Discussion (Misc queries) 3 January 23rd 09 04:35 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
No toolbars when viewed in IE mslee65 Excel Discussion (Misc queries) 1 March 7th 06 03:57 AM
excel file cannot be viewed FooYC Excel Discussion (Misc queries) 2 June 16th 05 11:02 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"