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.
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.