allow some users to edit only some columns
 

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

allow some users to edit only some columns
 

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?

allow some users to edit only some columns
 

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?

allow some users to edit only some columns
 

I don't have that version of Excel. In the one I did, I only used the basic
Protect/unprotect certain cells like it was just one setup, then for the
other sign-in's, the protect/unprotect of cells were set
differently.......all in code. Kinda brute-force, but it worked as long as
macros were not disabled.

Vaya con Dios,
Chuck, CABGx3



"serve" wrote:

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?