Hello Chuck,

Under Tools, Protection there is an option to "allow some users to edit
ranges" but even if you select the users, and protect the sheet after, they
can still edit the other columns they are not permitted to. How do you lock
it without locking it for the ones allowed?

Thanks.

"CLR" wrote:

I have done so before but it required the use of macros and a Sign-in sheet
so Excel would know who was using the file. But it's only as good as the
honesty of the users because it can be easily broken in to by a Guru.

hth
Vaya con Dios,
Chuck, CABGx3



"serve" wrote:

oHow do yu allow only some users to edit some columns and protect the rest of
the sheet?