G
google.com
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
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