What I am basically after is something like this:

Risk Probability Impact
BUR BU1 BUI1
TDR TD4 TDI1
TDR TD2 TDI2
TDR TD3 TDI5
BUR BU4 BU5

Each of these TDR, BUR, PR & GRP will feed into their own seperate look up
tables to get certain results dependent on their probability and risks.


"Otto Moehrbach" wrote:

Pasty
There's a couple of ways you can do that, both of which involve VBA.
One way is to have the VBA code lock those particular cells and/or
unlock the ones to which you want to retain access, then protect the sheet.
The other way is to have the code pop up a message box telling the user
that the particular cell is not available, then clear any selection made in
those cells.
Post back if this sound like what you want. HTH Otto
"Pasty" wrote in message
...
Is there a way of having it so if people select on option on a drop down
list
it will only let them edit a certain drop down box later in the sheet?
e.g.
If the select project risks the can only edit the drop down boxes relevant
to
them and same for bottom up risks etc.