| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation List on a shared workbook
I wrote a function that adds new drop down lists using data validation. This
works fine; when the user clicks a button it finds the next free row and adds the appropriate drop down lists in the correct columns to create a new row for filling in. My problem is that now I've done all this, when I share the workbook out it seems adding new validation parameters to build a list, is not available on shared work book! Is there any way I can still do data validation to build a drop down list on a shared workbook, or is there another way I can build my drop down lists dynamically on a shared book? Thanks in advance James |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation List on a shared workbook
try paste ur function here
"jss42" skrev: I wrote a function that adds new drop down lists using data validation. This works fine; when the user clicks a button it finds the next free row and adds the appropriate drop down lists in the correct columns to create a new row for filling in. My problem is that now I've done all this, when I share the workbook out it seems adding new validation parameters to build a list, is not available on shared work book! Is there any way I can still do data validation to build a drop down list on a shared workbook, or is there another way I can build my drop down lists dynamically on a shared book? Thanks in advance James |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation List on a shared workbook
You can't add or change data validation in a shared workbook. Perhaps
you could set up the data validation in the empty rows before you share the workbook. jss42 wrote: I wrote a function that adds new drop down lists using data validation. This works fine; when the user clicks a button it finds the next free row and adds the appropriate drop down lists in the correct columns to create a new row for filling in. My problem is that now I've done all this, when I share the workbook out it seems adding new validation parameters to build a list, is not available on shared work book! Is there any way I can still do data validation to build a drop down list on a shared workbook, or is there another way I can build my drop down lists dynamically on a shared book? Thanks in advance James -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation from list on separate Workbook | Excel Discussion (Misc queries) | |||
| Data Validation for list in a different workbook | Excel Discussion (Misc queries) | |||
| How can I get a validation to run in a macro on a shared workbook? | Excel Discussion (Misc queries) | |||
| Data Validation - using a list from another workbook | Excel Discussion (Misc queries) | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Linear Mode
