Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Protection Issue
Hi,
I am using Excel 2000. I have created a worksheet in which some of the cells have validation lists. I have protected the worksheet and unprotected the Validation cells so that when a user opens the sheet and clicks one of the validation cells, a pick list will appear. This works fine for myself and my collegues in my department. I have emailed this workbook to an external agent to look at. He is running Excel 2002 and is telling me that once he has opened the spreadsheet and attempts to choose one of the validation cells, he is presented with the ' The cell or workshhet you are trying to change is protected....' Has anyone seen this before or able to suggest why it i happening? I am hesitant in providing the 3rd Party agent with the unprotection password. TIA Ket London, UK |
#2
|
|||
|
|||
Are you sure the validation cells are unlocked?
In Excel 2000 and earlier versions, you can change the selection in a data validation dropdown, if the list is from a range on the worksheet. If the list is typed in the data validation dialog box, the selection can't be changed. In Excel 2002 and later versions, neither type of dropdown list can be changed if the cell is locked and the sheet is protected. This MSKB article has information on the previous behaviour: XL97: Error When Using Validation Drop-Down List Box http://support.microsoft.com/default.aspx?id=157484 Ket wrote: Hi, I am using Excel 2000. I have created a worksheet in which some of the cells have validation lists. I have protected the worksheet and unprotected the Validation cells so that when a user opens the sheet and clicks one of the validation cells, a pick list will appear. This works fine for myself and my collegues in my department. I have emailed this workbook to an external agent to look at. He is running Excel 2002 and is telling me that once he has opened the spreadsheet and attempts to choose one of the validation cells, he is presented with the ' The cell or workshhet you are trying to change is protected....' Has anyone seen this before or able to suggest why it i happening? I am hesitant in providing the 3rd Party agent with the unprotection password. TIA Ket London, UK -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
protection issue | Excel Worksheet Functions | |||
Cell Protection Color | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) |