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.
|