Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down boxes
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down boxes
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down boxes
You might be able to use dependent data validation, with the dependent
cells showing only an option of "N/A" unless a specific option is selected. There's information he http://www.contextures.com/xlDataVal02.html Pasty wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down boxes
This did work but then it occured to me that I could only have a section for
impacts or probabilitys relating to these and I need to have both coz I am going to be linking it all up to seperate lookup tables dependent on their outcome "Debra Dalgleish" wrote: You might be able to use dependent data validation, with the dependent cells showing only an option of "N/A" unless a specific option is selected. There's information he http://www.contextures.com/xlDataVal02.html Pasty wrote: 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. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down boxes
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Drop Downs Or Combo Boxes to Look up and display Info | Excel Discussion (Misc queries) | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Excel Drop Down Boxes | Excel Discussion (Misc queries) | |||
Copy drop down boxes and associate to cells dynamically in excel | Excel Worksheet Functions |