View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default XL window locks when working in VBE

sounds like you may have application.screenupdating set to false and it never
reset.

next time it happens, type application.screenupdating = true in the immediate
window and press enter. then see if the window is responsive.

--


Gary K



"salgud" wrote in message
...
Since my system was upgraded to WinXP and XL 11.5612.5606, I've been having
a problem with the XL window when working with the VBE. Usually after I've
had them both open for a while, the XL window locks, and won't come to the
front when I click on it. If I minimize it and restore it, the frame of the
XL window restores, but inside the window remains showing the desktop. No
cells or menus or toolbars! I have to close XL and reopen it to get rid of
this problem. I'm currently shutting down a few apps that run continuously
that might cause the problem, like my launcher and my notetaker to see if
they are part of the problem (longshot). Has anyone else seen a similar
problem? Anyone know a solution?
Thanks in advance.