how do i semi-lock a group of cells to allow lookups formula...

Q

quander

how do i semi-lock a group of cells to allow lookups formulas without
allowing user changes
 
T

tjtjjtjt

Do you mean you want to be able to reference these cells in lookup formulas
contained in other cells?
If so, leaving these cells locked (Format | Cells | Protection), and then
Protecting the Sheet (from teh Tools Menu) should be enough.
You may want to make sure you have Select Locked and Select Unlocked Cells
Checked, if a list of Protection Options pops up (Excel 2002 and later).

tj
 
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????
 
Top