Is there a way to lock down validations? Within the spreadsheet I am working with I am required to use lookup functionality but when I do the validation is removed despite all lookup returns always equaling one of the validation categories. Please see the attached file. Thanks in advance!
Last edited by usc1382; 10-28-2010 at 01:05 PM.
I'm not sure what you're asking. Where in your sheet do you have validation that is not locked down? Validation only works on cells where you are entering data manually so you cannot apply it to a cell with a formula in it. Is that what you are asking?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You answered it correctly in regards to only being able to use Validation with manual entries. Thanks for the help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks