Q
quander
The sheet doe’s get protected and cells are “properly†locked and unlocked,
but there is a strange occurrence that I find difficult to replete in some of
my cell groupings. I have lookup cells that reference other sheets. When I
change the data in the other sheets and go back to this sheet with a locked
cell the data does not change. If I do it with an unlocked cell the data
changed but the user can also change the cell. Some how I have a semi-grayed
locked selection in some of these lookups that allow me to change the data in
the other sheet and have it change in this sheet with out allowing the users
to access the cells. Does anyone know how I can repeat this????
but there is a strange occurrence that I find difficult to replete in some of
my cell groupings. I have lookup cells that reference other sheets. When I
change the data in the other sheets and go back to this sheet with a locked
cell the data does not change. If I do it with an unlocked cell the data
changed but the user can also change the cell. Some how I have a semi-grayed
locked selection in some of these lookups that allow me to change the data in
the other sheet and have it change in this sheet with out allowing the users
to access the cells. Does anyone know how I can repeat this????