N
nockam
Here is my delima. I have excel 2002 and i have a sheet that i do no
want anyone editing without entering in a password to unprotect it.
Currently i have every cell on the sheet locked. and I wanted to setu
some advanced permissions so that certain users dont even have t
unlock the file that part works great. This sheet background color
are used to indicate if the data has been processed or not ( not m
idea to do it that way ) so i want to make it so that if some rando
person that is not specified in my permissions list tries to change th
background color it wont let him without typing in a password
currently, when i protect the sheet if i mark the cell formatting bo
not even my allowed people can edit the background color. if i tak
that option off everyone can edit it. any suggestions? the way im goi
about this is tools, protection, allow users to edit ranges, i create
the ranges i needed, added permissions, and protected the sheet
want anyone editing without entering in a password to unprotect it.
Currently i have every cell on the sheet locked. and I wanted to setu
some advanced permissions so that certain users dont even have t
unlock the file that part works great. This sheet background color
are used to indicate if the data has been processed or not ( not m
idea to do it that way ) so i want to make it so that if some rando
person that is not specified in my permissions list tries to change th
background color it wont let him without typing in a password
currently, when i protect the sheet if i mark the cell formatting bo
not even my allowed people can edit the background color. if i tak
that option off everyone can edit it. any suggestions? the way im goi
about this is tools, protection, allow users to edit ranges, i create
the ranges i needed, added permissions, and protected the sheet