Taskpane turns disappears.
 

Hi There,

I'm running Excel 2003 SP2.

My code goes like this

* disable screen updating
* activate another sheet
* do some stuff there
* activate the sheet I originated from
* enable screen updating

My problem is that sometimes the Taskpane is showing - even though it
was not showing before I executed the code, and it is blank. There is
nothing in it and I have to do a "View/Task Pane" to get it refreshed,
and then I can remove again. I can't even make a CTRL+F1 which should
toggle the display of the taskpane. It is really annoying, because I
have to make a lot of Taskpane On/Offs to keep it hidden, which results
in flickering screens.

Has anyone else experienced the same problem?
Is it a bug in Excel?
Is there a workaround?

Flickering Cheers!
Hans

Taskpane turns disappears.
 

Hi again,

Just correcting the topic.

It should read "Taskpane content disappears"




skrev:
Hi There,

I'm running Excel 2003 SP2.

My code goes like this

* disable screen updating
* activate another sheet
* do some stuff there
* activate the sheet I originated from
* enable screen updating

My problem is that sometimes the Taskpane is showing - even though it
was not showing before I executed the code, and it is blank. There is
nothing in it and I have to do a "View/Task Pane" to get it refreshed,
and then I can remove again. I can't even make a CTRL+F1 which should
toggle the display of the taskpane. It is really annoying, because I
have to make a lot of Taskpane On/Offs to keep it hidden, which results
in flickering screens.

Has anyone else experienced the same problem?
Is it a bug in Excel?
Is there a workaround?

Flickering Cheers!
Hans