O
Otto Moehrbach
Excel 2002, WinXP
I have some code that opens another file, checks it for various criteria,
and closes that file. I have that code bracketed with the ScreenUpdating
False/True statements.
All this works just fine, except that the task bar at the bottom of the
screen jumps during this process of opening/closing of this other file.
Is there a way to "freeze" or otherwise prevent the task bar from
jumping during this section of my code?
My user says that the title bar at the top of the Excel window also
jumps, so the same question applies to that. Thanks for your help. Otto
I have some code that opens another file, checks it for various criteria,
and closes that file. I have that code bracketed with the ScreenUpdating
False/True statements.
All this works just fine, except that the task bar at the bottom of the
screen jumps during this process of opening/closing of this other file.
Is there a way to "freeze" or otherwise prevent the task bar from
jumping during this section of my code?
My user says that the title bar at the top of the Excel window also
jumps, so the same question applies to that. Thanks for your help. Otto