LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Task Pane Dave Krippner Setting up and Configuration of Excel 0 January 30th 08 03:51 AM
Task Pane add-in Bert Nargs Excel Discussion (Misc queries) 0 April 19th 07 11:44 AM
task pane Diane Excel Discussion (Misc queries) 2 November 25th 05 05:53 PM
task pane Diane Excel Discussion (Misc queries) 0 November 25th 05 05:14 PM
toolbar("Task Pane") problem!!!!!!! Andoni[_35_] Excel Programming 2 September 4th 04 03:44 PM


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"