You might have to try using a custom designed Data Form to allow the user
to select a row of data and edit it. Put a button on the worksheet that
calls up this form and then protect the worksheet and workbook with a
password. When the user edits a row of data, your macro would temporarily
unlock the worksheet/workbook, change the cells for that row, then re-lock
the worksheet/workbook again.

--
Regards,
Bill Renaud