You would need a macro, but even with a macro this is so easily defeated, it
isn't worth the effort.

--
Regards,
Tom Ogilvy



"jzifodya" wrote:


Hi Group

I am trying to prevent unauthorised editing of rows in an excel
spreadsheet. My intention is to have a column where individuals select
their initials from a list and once they have selected their initials
they are prompted to enter their password and the contents of the row
are locked i.e uneditable unless they (with the initials) enter their
password to edit or the administrator.

Can this be done in excel without writting a macro? If not what vb code
or macro can I use.


--
jzifodya
------------------------------------------------------------------------
jzifodya's Profile: http://www.excelforum.com/member.php...o&userid=35557
View this thread: http://www.excelforum.com/showthread...hreadid=553176