Hi Kevin,

Kevin McCartney a écrit :

Check your desktop properties relating to the screen resolution and color
quality properties. I've had it in the past where some one wanted to select
the entire sheet and it took forever because the machine had little RAM, but
after turning the color quality to low it ran as quick as ever, it could be
somthing similar, but give it a try, it may be that the two user logins have
different screen settings.

HTH and let us know how you get on.

Thanks for your tip. In the mean time i found a solution that solves my
problem. I noticed that the problem only occurs on sheets with the page
break displayed. So i add the follwing instructions before the changes
on the row height and auto fits.

ActiveWindow.View = xlNormalView
ActiveWindow.Zoom = 100
ActiveSheet.DisplayPageBreaks = False

After the height changes, I added this instruction to restore the
initial state.

ActiveWindow.View = xlPageBreakPreview


I still do not understand why the problem only occurs on some logins,
but i give up my investigations. In my case, the machine has enough
ram, and the display settings are the same.

Marc Klein