Eliminate Taskbar updates
You shouldn't really see anything jumping around in the task bar.
Or, maybe look at this (in XL97-2003)
Tools, Options, View, Windows in taskbar - uncheck
search help for similar in xl2007
Regards,
Peter T
"Otto Moehrbach" wrote in message
...
Excel 2007 Win 7 64-bit
I don't know if "Taskbar" is the proper term. I mean the bar at the
bottom of the screen that displays the icons and names of all open files.
I have some code that opens multiple files, one at a time, copies/pastes,
and closes the files. I set ScreenUpdating so that nothing is jumping on
the main screen. However, the "taskbar" is, of course, jumping around.
Is there a way to freeze that bar by code? Thanks for your time. Otto
|