Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Some of the changes cannot be viewed in track changes history. | Setting up and Configuration of Excel | |||
How do I password protect a SS & allow it to be viewed by others | Excel Discussion (Misc queries) | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
No toolbars when viewed in IE | Excel Discussion (Misc queries) | |||
excel file cannot be viewed | Excel Discussion (Misc queries) |