| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock down a defined name list - help!
I have an excel sheet that the first column contains drop downs to select a
code from another tab. I used Insert / Name / Define to choose the list. I have tried to lock every cell and protect the sheet and every cell works fine except where I have the drop downs. What is odd is that even the drop down cells are locked on my Excel (2003) but when I email it to my client (uses Excel 2000) it is not locked and he can click the drop down and choose codes. Please help - thanks! -Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
| Copying list item (a bit less vague) | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Threaded Mode
