PDA

View Full Version : Allowing validation on protected sheet



Johnpants
11-16-2005, 06:21 AM
Hi, I have a sheet that is protected, but I have 2 cells that have a validation list on them. Is it possible to allow these 2 cells to be edited? or allow the validation on the worksheet?

Thanks,

john.

OBP
11-16-2005, 06:34 AM
Yes you can "unprotect" the 2 cells in question.
You may also be able to use Tools>Protection>Allow users to edit ranges
if you have Excel 2000 or later.

Johnpants
11-16-2005, 07:09 AM
Thank you, I should have really known this! hehe.

Appreciate the help.