But what does the workbook being shared have to do with this? I said the
problem occurs only when shared.

--
Jim
"puba" wrote in message
oups.com...
Replaced before the "sort" instruction the following lines

Columns("A:P").Select
Range("P1").Activate

by

ActiveCell.CurrentRegion.Select

That way, only the current cells are sorted instead of the 65000 rows.

---------

puba a écrit :
As I don't know VBA, most of the code is "recorded".
I've heard that the "select" command is slowing down execution of the
code.

Perhaps, someone could simply tell me by what to replace the recorded
select code by a smarter alternative.