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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock down a defined name list - help!
Protection changed its behavior in xl2003 (or was it in xl2002???).
You have to unlock that cell in xl2003. Steve wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock down a defined name list - help!
What do you mean "have to unlock that cell in xl2003"? Its locked on my
version (2003) but when I send it to my client its not locked on his version (2000). He wants to email that file to his customers but I can't afford for the protection to be hit or miss. How do I ensure that it is locked/protected in all versions from 2000 on? And why would it lock everything except that column (where the drop downs are)??? Is there something different I can do? Thanks! "Dave Peterson" wrote: Protection changed its behavior in xl2003 (or was it in xl2002???). You have to unlock that cell in xl2003. Steve wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock down a defined name list - help!
I would guess that the cell is still locked in xl2k.
But excel's behavior changed. In xl2k, cells with data|validation could change a locked cell. In xl2003, it can't. So you can just unlock those cells (format|Cells|Protection tab). Steve wrote: What do you mean "have to unlock that cell in xl2003"? Its locked on my version (2003) but when I send it to my client its not locked on his version (2000). He wants to email that file to his customers but I can't afford for the protection to be hit or miss. How do I ensure that it is locked/protected in all versions from 2000 on? And why would it lock everything except that column (where the drop downs are)??? Is there something different I can do? Thanks! "Dave Peterson" wrote: Protection changed its behavior in xl2003 (or was it in xl2002???). You have to unlock that cell in xl2003. Steve wrote: 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 -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock down a defined name list - help!
But I need them locked.
So is there no way to lock those cells in xl2k??? Is there another way of doing a drop down list that would be able to be locked in xl2k? Thanks! "Dave Peterson" wrote: I would guess that the cell is still locked in xl2k. But excel's behavior changed. In xl2k, cells with data|validation could change a locked cell. In xl2003, it can't. So you can just unlock those cells (format|Cells|Protection tab). Steve wrote: What do you mean "have to unlock that cell in xl2003"? Its locked on my version (2003) but when I send it to my client its not locked on his version (2000). He wants to email that file to his customers but I can't afford for the protection to be hit or miss. How do I ensure that it is locked/protected in all versions from 2000 on? And why would it lock everything except that column (where the drop downs are)??? Is there something different I can do? Thanks! "Dave Peterson" wrote: Protection changed its behavior in xl2003 (or was it in xl2002???). You have to unlock that cell in xl2003. Steve wrote: 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 -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't lock down a defined name list - help!
Doesn't your data|validation stop users from entering invalid data?
Why would you need the cell locked if you have data|validation protecting it? Steve wrote: But I need them locked. So is there no way to lock those cells in xl2k??? Is there another way of doing a drop down list that would be able to be locked in xl2k? Thanks! "Dave Peterson" wrote: I would guess that the cell is still locked in xl2k. But excel's behavior changed. In xl2k, cells with data|validation could change a locked cell. In xl2003, it can't. So you can just unlock those cells (format|Cells|Protection tab). Steve wrote: What do you mean "have to unlock that cell in xl2003"? Its locked on my version (2003) but when I send it to my client its not locked on his version (2000). He wants to email that file to his customers but I can't afford for the protection to be hit or miss. How do I ensure that it is locked/protected in all versions from 2000 on? And why would it lock everything except that column (where the drop downs are)??? Is there something different I can do? Thanks! "Dave Peterson" wrote: Protection changed its behavior in xl2003 (or was it in xl2002???). You have to unlock that cell in xl2003. Steve wrote: 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
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) |