They aren't actually sorting the data. They are making groups based on
criteria that I don't have access to. So instead of moving the entire row
(which would be what should happen) they are only moving part of the row
(like the first 4 cells and accidentally leaving the last 3 cells in the
row), and then I don't know where the rest of the row belongs. Do that make
sense? Any way to "lock" the row so that it cannot be disasembled?

"CLR" wrote:

If your users are "moving entire rows around the worksheet", then that
probably means they are "grouping", or "sorting" the data to their
needs.........if that be the case, perhaps you can anticipate how they might
want the sorting done and set up macros with pushbuttons to do it for them,
thereby insuring the integrity of the data..........

Vaya con Dios,
Chuck, CABGx3


"Paula" wrote in message
...
Using Excel 2002 here, anybody know how I can allow a user to move entire
rows around the worksheet, but not let them select only a portion of the
row
only to move? I'm having trouble with people not selecting the entire row
when moving, then I have a mess.
Thanks, Paula