Missing "Watch Window" in Excel 2007 Visual Basic.

Question

I can no longer view the "Watch Window" in Excel 2007 Visual Basic.  I have undocked the "Immediate" and "Locals" window, and tiled all of them.  I cannot see the "Watch Window" at all.  The menu item "View/Watch Window" shows nothing?

Answer 1

You could try the following in the Immediate window to make sure the window is visible and positioned on the screen.

application.VBE.windows("Watches").visible=True

?application.VBE.Windows("Watches").Left

Answer 2

None of my windows would dock so I backed-up HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA, deleted the key and restarted all Office applications.  Problem solved.

Microsoft, my bill to you is $35 USD since I already paid for the software.

Thanks!

Answer 3

Unfortunately, I get "Runtime Error 1004"- "Programmatic access to Visual Basic Project is not trusted" when I try to run the above statements.

However, I found another post pertaining to lost windows on the Office forum.

As suggested in this post, the following fixed the problem.

I used REGEDIT to rename

              "HKey_Current_User\Software\Microsoft\VBA\6.0\Common\Dock"

                                            to

               "HKey_Current_User\Software\Microsoft\VBA\6.0\Common\Dock_Temp"

and then re-started Excel VBA.

This fixed the problem, I could now see all the variable windows "Locals, Immediate, Watch".

Then, as suggested, I deleted

                         "HKey_Current_User\Software\Microsoft\VBA\6.0\Common\Dock_Temp"