Workbook Validation

G

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
 
B

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)
 
D

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
 
Top