Workbook Validation

[Gordon Serkis]

I trying to change a validation list for all worksheets in a Workbook in one
entry. Can this be done?

Thanks for any help.

Gordo

 

[Bob Phillips]

You can change the list a validation refers to and if there are many
referrals they all reflect that change, but you cannot change many DV's in
one sweep without VBA.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Debra Dalgleish]

You can select all the cells with data validation, and change the list:

Choose Edit>Got To, and click the Special button
Select Data Validation, and choose All or Same, then click OK
Choose Data>Validation
Enter the new list, and click OK