| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting lists
How do I protect the cells in a list without stopping it from activating?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting lists
I'm assuming you've got data validation on one or more cells and that this validation refers to a list that you want to protect. A guess because it is unclear. If so unlock the cells that have the data validation, leave the list cells locked, and then protect the worksheet. lambertdarr Wrote: How do I protect the cells in a list without stopping it from activating? -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=534091 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare lists | Excel Worksheet Functions | |||
| Capitalize Text if 2 lists are equal | New Users to Excel | |||
| Excel - need a function to compare lists | Excel Worksheet Functions | |||
| Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions | |||
Linear Mode
