phantom 'Task Pane' problem
I have a workbook with a lot of vba code. Occasionally I see a
phantom task pane on the left side of the worksheet after running some
of the code. (phantom task pane = grayed out area the same size as
the 'Help' task pane that can be eliminated by opening up any normal
task pane and then closing the task pane) I found some posts from
2005 covering the same problem, but no real solutions (there was a
suggestion to add two lines to end of vba code:
Application.CommandBars("Task Pane").Visible = True and
then
Application.CommandBars("Task Pane").Visible = False. )
It works, but like I said earlier, there is a lot of code in this
workbook.
I did find that I could eliminate the problem if I removed a line of
code:
Application.ScreenUpdating=False
This of course makes the screen go crazy while the code is running.
Any suggestions? I'm running Windows XP and Excel 2003 SP3
|