View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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