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)

"Gordon Serkis" <[email protected]> wrote in message
news:JT9Fg.1796$rT5.872@fed1read01...
> 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
>
>

[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

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html