Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet protection interfering with data validation combo box pr
With help from this discussion board, I was able to get my spreadsheet data
validation to include the autocomplete feature. Now however, I want to add protection to the spreadsheet so the user won't accidentally change the cell contents (I have Vlookups in many of the cells) As soon as I add the protection the autocomplete feature stops working. Can this be fixed? Thanks -- Lele |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet protection interfering with data validation combo boxpr
If the worksheet is being protected, allow users to Edit Objects, and
they should be able to use the combobox with AutoComplete. Lele wrote: With help from this discussion board, I was able to get my spreadsheet data validation to include the autocomplete feature. Now however, I want to add protection to the spreadsheet so the user won't accidentally change the cell contents (I have Vlookups in many of the cells) As soon as I add the protection the autocomplete feature stops working. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Combo box drop down & worksheet protection | Excel Discussion (Misc queries) | |||
Page Protection interfering with Hiding Rows | Excel Worksheet Functions | |||
Data Validation Protection | Excel Discussion (Misc queries) | |||
Combo Box or Data Validation | Excel Discussion (Misc queries) |