Data Validation Lists in Protected Worksheet

[Erin]

I have a protected sheet (to which I don't know the
password) with data validation applied to certain areas.
I want to copy the lists being referenced by the drop
boxes, but the validation option is grayed out due to the
protection.

I have not been able to find the lists on the sheet and
there are no sheets xlVeryHidden.

Any suggestions?

Thanks!

Erin

 

[Jason Morin]

Unprotect the sheet by breaking the password, then click
on the cell and go into Data > Validation and see where
the source for the list resides.

http://www.straxx.com/excel/password.html

HTH
Jason
Atlanta, GA