I have 31 pages each with the same range I want to progam to validate the entry. it works fine for page 1, but when I highlight more than 1 worksheet to do them all at once the Validation comand is unavalible. The worksheets are unprotected. It is not a shared workbook. Is there a way to program validation to all at once or at least copy, paste validation?