| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I ensure a drop down list is used i.e by preventing printing
i want to make sure that the user selects a drop down box and changes it from
the default. So the box shows Select Here, and when the drop down list is selected they can pick Yes or No. If they don't pick yes or No i want to stop them printing or have a message come up or something to try and ensure they do it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
can I ensure a drop down list is used i.e by preventing printing
You could use conditional formatting to colour key cells black until the
selection is made. It wouldn't prevent users from printing, but they would have an incentive to make the selection. Have a Go wrote: i want to make sure that the user selects a drop down box and changes it from the default. So the box shows Select Here, and when the drop down list is selected they can pick Yes or No. If they don't pick yes or No i want to stop them printing or have a message come up or something to try and ensure they do it. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
| Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
| Conditional Use of List box (drop down) | Excel Discussion (Misc queries) | |||
| drop down list of a drop down list | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Linear Mode
