Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Task Pane | Setting up and Configuration of Excel | |||
Task Pane add-in | Excel Discussion (Misc queries) | |||
task pane | Excel Discussion (Misc queries) | |||
task pane | Excel Discussion (Misc queries) | |||
toolbar("Task Pane") problem!!!!!!! | Excel Programming |